isnull()

Function group Execute on client Platform(s)
General YES All

Syntax

isnull(expression)

Description

Returns true if the expression has value NULL.

Also returns true if fieldname, a field in the current record, is null. A null value is one where no value has been entered and the field definition is Can be null without Insert as Empty.

Example

Calculate lVar1 as  #NULL
Calculate lBoolean as  isnull(lVar1)
# returns true because lVar1 is null