By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,340 Members | 1,625 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,340 IT Pros & Developers. It's quick & easy.

How can I add NEW LINE to a report

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.