jwcolby
jwcolby at colbyconsulting.com
Sat Nov 3 16:21:31 CDT 2007
You can, but they need to be declared public. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Saturday, November 03, 2007 4:18 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Insert a new line in an expression? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com