[AccessD] Case Is = Null ??

Hi Dan

Move it to the Case Else section:

Select Case varTest
  Case n
  Case y
  Case Else
    If IsNull(varTest) Then
      ' Null
    Else
      ' Not Null
    End If
End Select
  
/gustav

>>> dwaters at usinternet.com 10-02-2006 17:32:05 >>>
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