Add new lines to a text box

  • Thread starter Thread starter Tony Wainwright
  • Start date Start date
T

Tony Wainwright

I am writing a report and I want to create a front page that gives the title
of the report. I have placed a text box in the ReportHeader and set the
ControlSource to ="Management Report For " & [HospitalName]. What I want the
output to look like is :

Management Report
For
HospitalName

Is this possible without writing code?
Thanks
TeeJay
 
="Management Report" & vbCrLf & "For " & vbCrLf & [HospitalName]

If you were trying to do this concatenation in a query, you'd need to use
Chr(13) & Chr(10), rather than vbCrLf.
 
Thanks Douglas
Douglas J. Steele said:
="Management Report" & vbCrLf & "For " & vbCrLf & [HospitalName]

If you were trying to do this concatenation in a query, you'd need to use
Chr(13) & Chr(10), rather than vbCrLf.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Tony Wainwright said:
I am writing a report and I want to create a front page that gives the
title of the report. I have placed a text box in the ReportHeader and set
the ControlSource to ="Management Report For " & [HospitalName]. What I
want the output to look like is :

Management Report
For
HospitalName

Is this possible without writing code?
Thanks
TeeJay
Click to expand...
Click to expand...
 
Back
Top