Chr(13) not entering carriage return in Query results

S

sfleck

In Access 2007 the following Query is returning a small box where the Hard
Return should be.

[Findings]![Description of Finding] & Chr(13) & [Findings]![Recommended
Counter]
 
D

Douglas J. Steele

You need Chr(13) & Chr(10), in that order.

Chr(13) is a carriage return, Chr(10) is a line feed.
 

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

Split data in field on character return 0
SQL Update Table Finding the Correct items to update but not Updat 1
Soft Carriage Return 6
Query Does not return all matching results 3
Problems with carriage return in address field 5
undefined function 'chr' in expresssion 2
Ignore nulls in concatenation 10
CHR(13) not working for carriage return 4

Top