Hi,

Can anyone help me with the following problem?

I'm having trouble removing the Enter key (13 hex) in my data record.
Ex : I have a memo type field and the user will enter all the information
into this field with the Enter key(sometime) as below.
line 1
line 2
line 3
But I need to get the output in my file as line 1 line 2 line 3.
Mean without the Enter key, so my data won't go to the next line.

As I know, in MS Excel we can use the CLEAN command, but this function is
fail on MS Access.

If anyone has a solution, please email me to swong@pcsmy.com.my
Any help greatly appreciated.

Thanks again.
SiaoWei