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