IsEmpty Function

Returns a Boolean value indicating whether a variable has been initialized.

Syntax

IsEmpty(expression)

The required expression argument is a numeric or string expression. However, because IsEmpty is used to determine if individual variables are initialized, the expression argument is most often a single variable name.

Remarks

IsEmpty returns True if the variable is uninitialized, or is explicitly set to Empty; otherwise, it returns False. False is always returned if expression contains more than one variable.

Example

This example uses the IsEmpty function to determine whether a variable has been initialized.

Dim MyVar, MyCheck


MyCheck = IsEmpty(MyVar)   ' Returns True.
Trace MyCheck


MyVar = Null ' Assign Null.
MyCheck = IsEmpty(MyVar) ' Returns False.
Trace MyCheck


MyVar = Empty ' Assign Empty.
MyCheck = IsEmpty(MyVar) ' Returns True.
Trace MyCheck

 

See Also

IsDate Function , IsNull Function , IsNumeric Function , VarType Function