[AccessD] Insert a new line in an expression?

Susan Harkins ssharkins at gmail.com
Sat Nov 3 15:18:08 CDT 2007


Someone smarter than me will need to verify this, but I don't think you can 
use vb constants outside of a module.

Susan H.


> 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.
>>
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list