a little square box appearing in the data

[aquinox]

Hi,

wondering if anyone might be able to help me here. It may be a trivial question here but I just couldn't solve it.

I would like to replace the "return carriage key" with something else but just don't know how to put it into code.

In the table, i can see that there are some that look like "little square box" symbol appearing in the data which i think could be the carriage return key (I'm not sure). And i like to replace it with something else

Here is the code
mytemp = replace(rsNew![Project Details],chr(13),"-") - doesn't do the trick.

Any ideas?

Thank you in advance

 

[PHV]

You may try Chr(10)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aquinox]

Thank you PHV,

It works now