[AccessD] Insert a new line in an expression?

Susan Harkins ssharkins at gmail.com
Sat Nov 3 12:43:10 CDT 2007


> 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. 




More information about the AccessD mailing list