[AccessD] help with a query...

Unfortunately, you can't use VB Constants in queries.
You have to use Chr$(13) & Chr$(10) in this situation.

--
Stuart

On 6 May 2009 at 16:47, Dan Waters wrote:

> Or 'vbNewLine'!
> 
> Dan
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Wednesday, May 06, 2009 4:24 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] help with a query...
> 
> Just a short comment:  you could save yourself a lot of typing if you use
> 'vbCrLf' instead of 'Chr(13)+Chr(10)'
> 
> Doug Steele
> --