Need new lines 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. I even ran it through a unix2dos utility
to make sure that the CR/LF's were in the file correctly
before I loaded it.

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
characters and displays new lines so that my reports
display correctly?

Thanks,

Dave
..

 

[Arvin Meyer]

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. I even ran it through a unix2dos utility
to make sure that the CR/LF's were in the file correctly
before I loaded it.

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
characters and displays new lines so that my reports
display correctly?

Make sure that the control character is not Chr(9) which is the Tab
character and can't be displayed in Access. Ig it is, just strip the
character out using the Replace() function.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

The question would be: _what_ character(s) are used to indicate a new line?
In Microsoft Access it must be Chr$(13) & Chr$(10), and they must be in that
order. That isn't the case in every application in Windows, so a general
*nix to Windows checker may not give you the proper indication.

Just FYI, in VBA code, there is an intrinsic constant vbCrLf that you can
use instead of spelling out the carriage return and line feed characters.

Larry Linson
Microsoft Access MVP