IS [NOT] NULL (Access 2013 custom web app)

Office 2013

Determines whether a specified expression is NULL.

Last modified: June 29, 2012

Applies to: Access 2013 | Office 2013

expression IS [NOT ] NULL

The IS [NOT] NULL predicate contains the following arguments.


Any valid expression.


Specifies that the Boolean result be negated. The predicate reverses its return values, returning TRUE if the value is not NULL, and FALSE if the value is NULL.

If the value of expression is NULL, IS NULL returns TRUE; otherwise, it returns FALSE.

If the value of expression is NULL, IS NOT NULL returns FALSE; otherwise, it returns TRUE.

© 2014 Microsoft