Carriage Return and Line Feed

  • Thread starter Thread starter Deb Struble
  • Start date Start date
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!
 
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
 
Back
Top