Line breaks in text imported by ODBC into Memo Fields

#1 (**permalink**) 28-Jul-2006, 08:16 AM

I'm importing an OMNIS file. Long text fields go into Access memo fields, but
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10819-line-breaks-text-imported-odbc-into.html
line breaks in the text are left as a little square character. Is there a way
to make the memo field separate the lines?

*

#2 (**permalink**) 28-Jul-2006, 08:16 AM

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10819

"Jerry K" wrote in message
news:88E96B7B-757B-4CD8-87F3-C7A543AD6BC9@microsoft.com...
> I'm importing an OMNIS file. Long text fields go into Access memo fields,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10819
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?