Description
The IsNull() function returns a Boolean value that indicates whether a specified expression contains no valid data (Null). It returns True if expression is Null; otherwise, it returns False.
This function has the form:
IsNull(expression)| Parameter | Description |
|---|---|
| expression | (required) An expression |
Examples
The following example shows the basic use of this function:
Dim x
Msgbox(IsNull(x))
x=10
Msgbox(IsNull(x))
x=Empty
Msgbox(IsNull(x))
x=Null
Msgbox(IsNull(x))
This produces the following result (each line in a separate pop-up message box):
False
False
False
True
Miscellaneous Information
| Supported in Version: | 1.0 |
|---|