Line breaks in text imported by ODBC into Memo Fields



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question