Function

What it Does

Comments

IsArray(varname)

Returns a Boolean indicating whether varnameis an Array.

IsDate(varname)

Returns a Boolean indicating whether varnameis capable of being converted to Date.

IsEmpty(varname)

Returns a Boolean indicating whether varnamehas been initialized.

Use this for both number and string variables

IsError(varname)

Returns a Boolean indicating whether varnameis an Error.

IsMissing(vntname)

Returns a Boolean indicating whether an optional Variant(vntname) has been passed to a procedure.

Returns True if no value has been provided for vntname

IsNull(varname)

Returns a Boolean indicating whether varnamecontains no data or is Null.

You cannot test for a Null value by using a statement like:

If (vntB = NULL)

This latter test will always fail.

IsNumeric(varname)

Returns a Boolean indicating whether varnamecan be evaluated as a Numeric.

IsObject(varname)

Returns a Boolean indicating whether varnamerepresents an Object