Carriage Return

[Eddie Mason]

I have a memo field in a table into which I have imported 2000 records these however appear formatted with paragraphs starting on a new line. Because I’m exporting it into a third party application I need to remove the carriage return to make the text one continuous string with no line breaks.

Is there a way that I can remove the carriage returns without manually going through each record?

I would be grateful for any help,

kind regards,

Eddie

 

[vbaInet]

Eddie,

You will need an UPDATE query, the Replace() function and the newline character which is Chr(13)

Look into those.

 

[Eddie Mason]

Many thanks for your help, it really is appreciated it is know working perfectly.

Kind regards,

Eddie

 

[vbaInet]

Good to hear Eddie!