Forcing a field to the next line in an text box

Is there a command that I can add to a text field in a report that would force the second field to the next line on a report?  See below an example of the expression:

=[Address1]&”   “&[Address2]

I need Address2 force to the second line (I have already tried setting the field to shrink, which do move up the line below it, but if there is a Address2, I need it on a different  line below Address1
Delores_CAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mbizupConnect With a Mentor Commented:
Are you trying to add a carriage return?

=[Address1] & chr(13) & chr(10) & [Address2]

Open in new window

0
 
mbizupCommented:
If you need a space between the lines:



 =[Address1] & chr(13) & chr(10)  & chr(13) & chr(10) & [Address2] 

Open in new window

0
All Courses

From novice to tech pro — start learning today.