Microsoft Access Function Library: IsEmpty()

[bbasujon]

Function: IsEmpty()

Purpose: The IsEmpty function returns a value of true if the referenced variable has not been initialized. Otherwise, it returns false.

Usage: IsEmpty(variable_name)

Where variable_name is the name of the variable you wish to test.

Returns: True if the referenced variable has not been initialized; False otherwise.

Example

Dim TestEmpty
TestArray = Array(1,2,3)
TestInt = Int(1)
TestDate = "June 10, 2000"
IsEmpty(TestEmpty) returns True
IsEmpty(TestArray) returns False
IsEmpty(TestInt) returns False
IsEmpty(TestDate) returns False