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(tblOwnerInfwnerTitle),'',tblOwnerInfwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfwnerFirstName),'',tblOwnerInfwnerFirstName & '
') & IIf(IsNull(tblOwnerInfwnerLastName),'',tblOwnerInfwnerLastName) &
***FORCE NEW
LINE***IIf(IsNull(tblOwnerInfwnerAddress),'',Replace(tblOwnerInfwnerAddress,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(tblOwnerInfwnerTitle),'',tblOwnerInfwnerTitle
& ' ') &
IIf(IsNull(tblOwnerInfwnerFirstName),'',tblOwnerInfwnerFirstName & '
') & IIf(IsNull(tblOwnerInfwnerLastName),'',tblOwnerInfwnerLastName) &
***FORCE NEW
LINE***IIf(IsNull(tblOwnerInfwnerAddress),'',Replace(tblOwnerInfwnerAddress,Chr(13)
& Chr(10)," ")) ***FORCE NEW LINE*** &
IIf(IsNull(tblOwnerInfo.Email),'',tblOwnerInfo.Email & ' ')