contents.gifindex.gifprev1.gifnext1.gif

IsEmpty

Purpose

Returns a value indicating whether or not a Variant variable has been initialized.

Arguments

IsEmpty( variant )

Notes

The argument variant can be any Variant expression. However, because IsEmpty is used to determine whether or not variables are initialized, the argument is most often a single variable name.

The IsEmpty function returns True (-1) if the Variant contains the Empty value; otherwise, it returns False (0). When an expression contains more than one Variant, IsEmpty returns True only when all of the variables in the expression are Empty. The Empty value indictes that a Variant hasnt been initialized. Empty is not the same as Null, which indicates that a Variant contains no data.