Tina Norris Fields
tinanfields at torchlake.com
Sat Nov 3 12:35:17 CDT 2007
Arthur, I wanted to use that constant, but I am not succeeding. When I write: =Trim( Iif( [MailAddr1] Is Not Null, [MailAddr1] & vbCrLf, "")& [MailAddr2]) Access treats vbCrLf not as a constant but as a parameter. What am I doing wrong? Tina Arthur Fuller wrote: > Or use the constant vbCrLf. > > Arthur > > On 11/3/07, Joe O'Connell <joeo at appoli.com> wrote: > >> Tina, >> >> You need both Carriage Return (ASCII 13) and Line Fee (ASCII 10). Use >> Chr(13) & Chr(10) instead of " ". >> >> Joe >> >>