Isnull()

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Other Functions > Isnull()

 

ISNULL() determines if a record contains a null value. ISNULL() works on all field types.  When the record within a field is null, the function returns true, otherwise it returns false.

 

 

Function Format

 

ISNULL(value) 

 

 

Return Value

 

ISNULL() returns a Boolean value 

 

 

Examples

 

ISNULL("123") = FALSE

 

ISNULL("ABC") = FALSE

 

ISNULL(null) = TRUE