Carriage return for text field from Union query

M

MeSteve

I have a union query where 2 fields are concatenated with Chr(13) & Chr(10)
in between (ex. textA & Chr(13) & Chr(10) & textB). This works on the query
datasheet view, but not in the report that runs off of this query. In the
report it is showing the 2 squares.

What am I missing? Thanks.
 

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 Return 2
mailing labels - square box at end of first line in report 8
Report control: hide blank row when null data 2
Union All query truncating 18
how to insert CRLF (carrage return/line feed) in report 8
Report Text Box Force Line Carriage Return and Line Feed 1
Inserting carriage return in report field 3
Soft Carriage Return 6

Top