Carriage return in Report

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

Guest

In code, I use vbcr to get a new line in a message box. How do I force a new
line in a text box on a report? Do I just use two text boxes? Mainly curious.

Example control source:
[Fname] & " " & [Lname] & vbcr & [Address]
 
rpurosky said:
In code, I use vbcr to get a new line in a message box. How do I force a new
line in a text box on a report? Do I just use two text boxes? Mainly curious.

Example control source:
[Fname] & " " & [Lname] & vbcr & [Address]
Click to expand...


In VBA you can use vbCrLf or vbNewLine.

In a text box (or query) expression, use Chr(13) & Chr(10)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding a Carriage Return or Line Feed character to an update query 2
Excel Need assistance with modifying a Duplicate declaration. 13
Excel Message box called if 1 of 3 options is entered. 4
Split data in field on character return 0
tell form not to display data from empty boxes 3
Active XText box vbcr shows symbol instead of an actual carraige return 2
Input box and carriage return for chart title 2
Carriage return within document field? 6

Back
Top