How to force a new line!

B

Bob

Where I have ***FORCE NEW LINE*** I want to add to this code so as it will
start on the next line to it will print in report like this format on 3
lines, thanks for any help with this code........Bob
Name
Address
Email
--

NameAddress: IIf(IsNull(tblOwnerInfo.OwnerTitle),'',tblOwnerInfo.OwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName & '
') & IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName) &
***FORCE NEW
LINE***IIf(IsNull(tblOwnerInfo.OwnerAddress),'',Replace(tblOwnerInfo.OwnerAddress,Chr(13)
& Chr(10)," ")) ***FORCE NEW LINE*** &
IIf(IsNull(tblOwnerInfo.Email),'',tblOwnerInfo.Email & ' ')
 
R

Rick Brandt

Bob said:
Where I have ***FORCE NEW LINE*** I want to add to this code so as it
will start on the next line to it will print in report like this
format on 3 lines, thanks for any help with this code........Bob
Name
Address
Email

Use...

ExistingStuff & Chr(13) & Chr(10) & MoreExistingStuff

(in that order)
 

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

Top