Why's the sky blue? g

Jet queries do support that sort of thing and in VBA code I'd use something
like this:

"[Email1Address] " & Chr(34) & Chr(34)

However in .NET code I've found many cases where a property is not there
even if in VBA code it would be null string. It might be null string or null
(Nothing) in .NET code. So for me it's a lot easier to avoid that possible
problem and to just use DASL syntax for the search. Personal preference plus
some experience.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Craig Buchanan" wrote in message
...
Ken-

Thanks for the reply.

Why don't Jet queries support IS NULL or ''?

Thanks,

Craig