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...
 
Back
Top