Carriage Return and Line Feed

D

Deb Struble

I have a report that pulls data from a linked SQL Table. One of the fields
from the linked table is a text field. The carriage returns and line feeds
show up as sqaure boxes in this text field. How can I format this field on
my report so that when the sqaure box shows up it actually starts a new row
rather than displaying the square box?
Thanks!
 
D

Duane Hookom

I expect the single square box is probably Chr(10). You could try set the
control source to:
=Replace([FieldName],Chr(10), Chr(13) & Chr(10))
Make sure the name of the text box is not also the name of the field. In
this sample, change the text box name to:
txtFieldName
 

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

Carriage Returns in an Access report. 1
Carriage Return or Line Feed 1
Getting Line Feeds to Display 1
Line feed - carriage return characters 1
Insert carriage return and line feed in a report? 1
how to insert CRLF (carrage return/line feed) in report 8
Inserting carriage return in report field 3
Split data in field on character return 0

Top