Box in a text cell between lines of data

S

shell

I use "Alt + Enter" to go to another line of text in a cell in a table.
Then I link this table to an Access database. When I do a report in
Access using the linked table I get a "box" symbol between words where I did the
"Alt + Enter". How can I get rid of the box ?

Ex: Proposed Building
123 Main Street
Anywhere, PA

shows up as: Proposed Building (box) 123 Main Street (box) Anywhere, PA
 
D

Debra Dalgleish

In an Access query, you could replace the line break with a carriage
return and line break. For example:

RevAddress: Replace([Address],Chr(10),Chr(13) & Chr(10))

Base the report on the query, and use the RevAddress field, instead of
the Address field in the report.
 
Top