[AccessD] Insert a new line in an expression?

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



More information about the AccessD mailing list