Trying to find a new line in combining fields

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I have been trying to combine fields, using queries and reports, to create
an address ready for mailing, such as

PersonName
Address
CityStateZip

I can do all of this but I can't force the new line (carriage return in
typewriter-speak). I have tried using Chr(10) & Chr(13) but that doesn't
work.

How is this done?
 
I have been trying to combine fields, using queries and reports, to
create an address ready for mailing, such as

PersonName
Address
CityStateZip

I can do all of this but I can't force the new line (carriage return in
typewriter-speak). I have tried using Chr(10) & Chr(13) but that
doesn't work.

How is this done?
Click to expand...

You have the right idea, but the wrong sequence. Chr(13) comes first.

=PersonName & Chr(13) & Chr(10) & Address etc...
 

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
Problems with carriage return in address field 5
address in one line 4
Skipping lines in multiple line address query 3
Record with multiple lines 1
Memo Field with blank first line 1
Create data in a field with multiple lines? 2
adding a Carriage Return or Line Feed character to an update query 2

Back
Top