Edit

IS [NOT] NULL (Access custom web app)

  • Article

Determines whether a specified expression is NULL.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Syntax

expression IS [ NOT ] NULL

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

Value Description
expression
Any valid expression.
NOT
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.

Remarks

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.