Carriage Returns in an Access report.

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
You need a Carriage Return and Line Feed pair, i.e. Chr(13) & Chr(10) to get
them to behave properly.
 
Back
Top