Adding a line break in a field of a report

  • Thread starter Thread starter Bob O.
  • Start date Start date
B

Bob O.

Can I add a line break in a report. An example would be
[QTY_ENG]&" English"&[QTY_GER]&" German]. I would like
the report to show the English result on one line and the
German result below it. I am using Access 2000. I am a
relatively new user...but I can follow directions if
anyone can help.

Thanks
 
In a query, it would be [QTY_ENG] & " English"& Chr(13) & Chr(10) &
[QTY_GER] & " German"

In VBA, you can use [QTY_ENG] & " English" & vbCrLf & [QTY_GER] & " German"
 
[QTY_ENG] & " English" & vbCrLf & [QTY_GER] & " German"

If you want to concatenate in a Query, you may need to use Chr(13) & Chr(10)
instead of the symbolic constant vbCrLf.
 
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

Line break in Report expression builder 3
Report: Multiple lines in a textbox from a field 2
Text and Memo field concatenation - Line break (Access 2007) 4
Phantom debug break points in MS Access VBA code. 6
Can I cause a line feed break at a comma in a text string, in a re 1
Excel Create a New line in a Word Link without double "" around result 0
report page break question 1
Line Break Icon 1

Back
Top