[AccessD] Case Is = Null ??

Case IsNull

or Case Is Null
'
not sure which one.

Jeffrey F. Demulling
Project Manager
U.S. Bank Corporate Trust Services
60 Livingston Avenue
EP-MN-WS3C
St. Paul, MN  55107-2292
Ph: 651-495-3925
Fax: 651-495-8103
Pager: 888-732-3909
Text Messaging: 8887323909 at my2way.com
email: jeffrey.demulling at usbank.com


                                                                           
             "Dan Waters"                                                  
             <dwaters at usintern                                             
             et.com>                                                    To 
             Sent by:                  "AccessD"                           
             accessd-bounces at d         <accessd at databaseadvisors.com>      
             atabaseadvisors.c                                          cc 
             om                                                            
                                                                   Subject 
                                       [AccessD] Case Is = Null  ??        
             02/10/2006 10:32                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                  "Access                                                  
                Developers                                                 
              discussion and                                               
             problem solving"                                              
             <accessd at database                                             
               advisors.com>                                               
                                                                           
                                                                           




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




------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
==============================================================================