Carriage Returns in an Access report.

G

Guest

In access I have linked a table that contains a field with carriage returns.
Manipulated the data via a query, and built a report that displays the
contents the field with carriage returns in an access report. The carriage
returns are not recognized in the access report, but rather a square box is
displayed. If I copy the text directly from the query and paste into a word
document the carriage returns and line feeds act as expected. Why do I get a
little square box instead of separate lines of text?
Thx,
 
A

Allen Browne

You need a Carriage Return and Line Feed pair, i.e. Chr(13) & Chr(10) to get
them to behave properly.
 

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

Similar Threads

Outputting a report to Word 2
Box characters appearing instead of carriage returns 4
Getting Line Feeds to Display 1
Inserting carriage return in report field 3
Carriage Returns in my data as a box 7
Carriage Return and Line Feed 1
memo fields with carriage returns won't report complete record 4
Carriage returns in control source 1

Top