Access 2003 Database Removeal of CR

[stewartrose]

Hi Keith,

Sounds very logical, that you for the help and advice, and thanks to everyone else....

Best regards from Alan

 

[RuralGuy]

The problem character seemed to be a LineFeed. I ended up replacing any Cr I found with a CrLf sequence and stripping all other Control Codes. That seemed to resolve the issue.

 

[RuralGuy]

It actually formats better if we replace the Lf character with vbCrLf and strip all of the Cr's. My guess is that Access handles a CrLf sequence propertly but barfs on Lf alone or LfCr in the reverse order.