dnkurniawan
25th June 2014, 07:23
Hi all,

i need your help. how the way to get text in table tttxt010.text
Because when i try to get in Ms. Access it is show like this:摁⁤慓敬⁳慓灭敬愠摮䘠䈦䤠整牧畯⁰湩猠污獥爯癥湥敵䄠慮祬楳ੳ†††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††

I dont know why that show like that. But in the worktop the text is show normal.

Thanks

bhushanchanda
25th June 2014, 10:47
Hi,

Try using text.to.buf()

Here's a similar thread with the usage:- Thread (http://www.baanboard.com/baanboard/showthread.php?t=57249)

dnkurniawan
26th June 2014, 10:42
Hi,

Try using text.to.buf()

Here's a similar thread with the usage:- Thread (http://www.baanboard.com/baanboard/showthread.php?t=57249)

--

I try to build this Report in MS. Access, does this "text.to.buf()" function can be implemented in MS Access.

Thank you

bhushanchanda
26th June 2014, 11:40
Hi,

I am not sure about the requirement. text.to.buf() can be used to get the text present in tttxt010 or header/footer texts present in tables like tdsls400, 401 etc

podolzky
26th June 2014, 12:53
Hi,

i also need this text report (from tdsls401)for MS Access query, so is it possible to take out this 'symbol' in ttxt010 become normal word/sentence?

Thanks

podolzky
26th June 2014, 12:59
Hi,

I also need to take out text report in MS Access(from tdpur401), so is it possible to take out this text 'symbol' in tttxt010 into normal word/sentence?

what other option do we have?
and considering i want to use this 'text.to.buf()' function, where i should put this script?

thanks

bhushanchanda
26th June 2014, 15:23
Hi,

As mentioned, check check the thread. You can get the text in some variable and use it in your MS Access reports.

dnkurniawan
1st July 2014, 11:51
Hi just found the solution :)

in access it is use for the Strconv(String).
Thanks for your help.