concatenated report field / force a line break

  • Thread starter Thread starter Guest
  • Start date Start date
G

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