IsNull Function

Syntax

IsNull(expr)

Group

Variable Info

Description

Return the True if expr is Null.

Parameters

Parameters	Description
expr	A variant expression to test for Null.

Example

---

Sub Main
    Dim X As Variant
    Debug.Print IsEmpty(X) 'True
    Debug.Print IsNull(X)  'False
    X = 1
    Debug.Print IsNull(X)  'False
    X = "1"
    Debug.Print IsNull(X)  'False
    X = Null
    Debug.Print IsNull(X)  'True
    X = X*2
    Debug.Print IsNull(X)  'True
End Sub

See also

IsNull, TypeName, VarType