Function: IsEmpty

Description

Returns 1 if the character field is empty, otherwise returns 0 (zero).

Note: If you wish to determine whether a numeric or date field is empty, use the IsNull function.

Syntax

IsEmpty(field)

Arguments

field can be the name of any character field in the table.

Return value

This function returns a number: 1 if the field is empty, 0 (zero) if the field contains data.

Calculated field example

If the Name field contained no value, the following calculated field expression would return a 1, indicating that the field is empty: IsEmpty(Name)

Filter/Find example

Records with a blank Name field can be selected or found using the expression: IsEmpty(Name)=1