concatenated report field / force a line break

[Guest]

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

 

[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."

 

[Guest]

Thanks so much,

I used the first option and that worked great.

Brook