How can I add NEW LINE to a report

[galsaba]

Say I have a field called "First Name"
and field "Last Name".
comments.
I want to insert a NEW LINE afer few words.
I wrote a query with a field called "Full Name".
Full Name: [First Name] & [Last Name]
but I want to have a new line between First Name and Last Name.
I tried [First Name] & Chr(13) & [Last Mame]
but did not get new line...
any help would be greatly appreciated.

thanks
galsaba

[Douglas J. Steele]

Either Chr(13) & Chr(10) in that order, or the intrinsic constant vbCrLf.
Note that vbCrLf won't work in all cases: for example, you cannot use it in
a query, whereas you can use Chr(13) & Chr(10)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"galsaba" <ga*****@aol.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Say I have a field called "First Name"
and field "Last Name".
comments.
I want to insert a NEW LINE afer few words.
I wrote a query with a field called "Full Name".
Full Name: [First Name] & [Last Name]
but I want to have a new line between First Name and Last Name.
I tried [First Name] & Chr(13) & [Last Mame]
but did not get new line...
any help would be greatly appreciated.

thanks
galsaba