[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

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
0
Delores_C
Asked:
Delores_C
  • 2
1 Solution
 
mbizupCommented:
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now