concatenated report field / force a line break

B

Brook

Good day,

I have a report field that I have contatedated for my address:
AddressLine1, AddressLine2, and AddressLine3.

How can I for a new line so that each of the above are located on separate
lines within my Text Box?

Thanks,

Brook
 
R

Rick B

Either of the following should work. I think option 2 can be used in vba,
while option 1 can be used in a text box.


= "This is line 1." & chr(13) & chr(10) & "This is line 2."







= "This is line 1." & vbcrlf & "This is line 2."
 
Top