Last updated: August 26, 2026.
The IsNull function returns True when an expression contains Null and False otherwise.
Syntax
IsNull(expression)| Argument | Description |
|---|---|
expression | Value or field to test |
Examples
IsNull([ShippedDate])
Status: IIf(IsNull([ClosedAt]), "Open", "Closed")
SELECT * FROM Orders WHERE ShippedDate Is Null;Null is not the same as an empty string or zero. In SQL criteria, use Is Null; in expressions and VBA, use IsNull.
See Microsoft’s Access function reference for related expression functions.
