CR/LF in report

[Dave]

I have an Access 2002 database that has a linked table
that contains text. When I view the data in the table it
has the small control character squares instead of
displaying it as a new line. The data that is loaded into
the linked table has CR/LF's in it and looks fine (the new
lines are in there) if I look at it in an editor or
anything else.

This is causing and issue in my reports where I need the
new line in order to read the text effectively. Any ideas
on what I need to do so that the report recognizes the
appropriate new line so my reports display correctly?

Thanks,

Dave

 

[SA]

Dave:

Believe it or not you might simply try reversing the LF/CR and see if that
helps.