[AccessD] Case Is = Null ??

Hi Dan
I'm probably about to be proved wrong but I don't know that you can handle a
Null within a Case statement. I'd handle it outside, ie

If IsNull(var) then
Else
Select Case var
..

Be interested to see if anyone knows otherwise.

--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "AccessD" <accessd at databaseadvisors.com>
Subject: [AccessD] Case Is = Null ??
Date: 10/02/06 16:34


I need to do a Select Case where one of the value could be null. I thought
that Case Is = Null is the correct syntax, but is ignored when the value is
null.

What's the correct way to do this?

Thanks,
Dan



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2