Tina Norris Fields
tinanfields at torchlake.com
Sat Nov 3 14:25:50 CDT 2007
Hi Susan, It's in a textbox control on a report. Does that have the same constraints as a query? Thanks for thinking about it for me. Tina Susan Harkins wrote: >> When I write: >> =Trim( Iif( [MailAddr1] Is Not Null, [MailAddr1] & vbCrLf, "")& >> [MailAddr2]) >> Access treats vbCrLf not as a constant but as a parameter. >> > > =====Is this in a query expression? I don't think you can use vb constants > in a query expression. > > Susan H. > >