Trying to find a new line in combining fields

[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?

 

[Rick Brandt]

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?

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

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