address labels with a hard return space between lines

[wz]

I am creating lables in Access (I do not want the end user to merge into Word for this one) and I am having some prob. Several customers have a mailto address that needs to be used instead of their physical address - so I created a query that has the fields below & I want a line break between [companyname] and [1] and another break (hard return)between [2]. How can I do this? What is the code for a break? (I know in Word it is ^b)

=Trim([CompanyName] & [1] & [2])
I want it to look:

Joe Smith
40 Ave
New York....

not
Joe Smith40AveNewYork
(a line not everything run together)

 

[PWise]

how about

=Trim([CompanyName] & vbcrlf &  [1] & vbcrlf & [2])

 

[wz]

strange but true....
when I pasted it into the control source on the properties menu it takes away the vbcrlf...& when I type it in too. Any more ideas?

 

[wz]

I tried this & this works....Chr(13) + Chr(10) Thanks a ton!