>Thanks Eric. The shorter syntax was what I was looking for. I've been using the VB constant Null not vbNullString. What's the difference?
My error. vbNullString is returning an empty string. You should use Null.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com