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 & ' ')
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
--
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 & ' ')