Remove carriage returns from a text file

[Mike Hicks]

I have a text file exported from Access. I need to create that file as one
long string with no carriage or line returns.

 

[fredg]

I have a text file exported from Access. I need to create that file as one
long string with no carriage or line returns.

If you have a version of Access that supports the Replace function,
you can use:

NewField:Replace([OldField],chr(13) & chr(10),"")

Note:This replaces the return with nothing so you may get text running
together,
"This is line oneThis is line two"

If you want at least a space between the last and first word, use " "
as the replace with argument.