Daffodil Computers Ltd.

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:20:52 PM

Title: Microsoft Access Function Library: IsEmpty()
Post by: bbasujon on August 15, 2012, 05:20:52 PM
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