Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Forcing a new line in a text box

Status
Not open for further replies.

modalman

Programmer
Feb 14, 2001
156
GB
Hi. I'm creating a report that contains addresses. Each address is obtained from various fields. The text box is set to grow automatically and it contains the following:

=[Field11] & Chr$(13) & [Field12] & " " & [Field13] & " " & [Field14]

However the Chr$(13) doesn't force a newline to start in the text box. How can I do this? Also when the text box does grow the text box below it doesn't shift down. Have I missed a property setting somewhere on the report that enables it to do this? Many thanks in advance
Modalman

ASCII silly question, get a silly ANSI
 
Try vbCrLf:
=[Field11] & vbCrLf & [Field12] & " " & [Field13] & " " & [Field14]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top