Cleaning a Access Memo Feild of returns

[Mattster]

I am trying to a data transfer to SQL and therefore I need to clean all of the text feilds such that the returns are modified to an odd string so that I can post process it on the other end, otherwise the transfer, fails in sooo many ways, lol. (I have currently tried ^| which is the process in other microsoft softwares but access doesn't seem to recognize)

Currently, I have found a way to export the information to word and do the processing there, but I would prefer to avoid this if at all possible.

Any assistance would be appreciated. Thanks

 

[HiTechCoach]

Have you tried using the Replace() function.

Something like:

Replace([YourFieldName], Chr(13) & Chr(10), "")

 

[MSAccessRookie]

Have you tried using the Replace() function.

Something like:

Replace([YourFieldName], Chr(13) & Chr(10), "")

I was thinking of suggesting that the Replace() Function was the right tool, but you beat me to it. I do have one question though. Wouldn't it be better to use " " as opposed to ""? This would prevent successive lines from running into each other.

Replace([YourFieldName], Chr(13) & Chr(10), " ")[/quote]

 

[boblarson]

This would prevent successive lines from running into each other.

Good point