[AccessD] Insert a new line in an expression?

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



More information about the AccessD mailing list