<-- Previous || Up || Next -->

Variant Is Blank Function
Convert Values Class

Public Function VariantIsBlank( _
    ByVal vValue As Variant _
    ) As Boolean

Return True if argument is Empty, Null, or a blank String.
Function returns False otherwise.

    VariantIsBlank(Null) = True
    VariantIsBlank(EmptyValue) = True
    VariantIsBlank("") = True
    VariantIsBlank("Word") = False
    VariantIsBlank(0) = False
    VariantIsBlank(123) = False
See also:
    NullToBlank Function
    EmptyToBlank Function
vValue: The value that will be examined to see if it is Empty, Null, or a blank String.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.