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)
 
Back
Top