Line breaks in text imported by ODBC into Memo Fields

[Jerry K]

I'm importing an OMNIS file. Long text fields go into Access memo fields, but
line breaks in the text are left as a little square character. Is there a way
to make the memo field separate the lines?

 

[Douglas J Steele]

The line breaks must be the combination of Carriage Return (Chr$(13)) and
Line Feed (Chr$(10)), in that order (you can use the intrinsic constant
vbCrLf). Odds are you've only got one of the two characters in your text.

Try using the Replace function: either Replace([MyText], Chr$(13), Chr$(13)
& Chr$(10)) or Replace([MyText], Chr$(10), Chr$(13) & Chr$(10)), depending
on what's actually in your text.