Adding a line break in a field of a report

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
 
D

Douglas J. Steele

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"
 
V

Van T. Dinh

[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.
 
Top