SEarch for and replace carriage return in a memo field

[Phillb]

I have made a database that users can enter information into a memo field. I then want to export that data into another application via CSV file. I want to search a field for that carriage return (I know that Access puts the ascii 13 character into the field) and replace it with "\n". Any ideas?

 

[RuralGuy]

Have you looked at the Replace() function?

 

[gemma-the-husky]

note that a new line in vba is not just cr (ascii chr(13))

its
cr and lf (carriage return and line feed)

the vb constant for this is vbcrlf

it consists of chr(13) AND chr(10)

so if you just replace the chr(13) you MAY get odd results