MS Access - Remove Enter Key from the data
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.
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 firstname.lastname@example.org
Any help greatly appreciated.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center