Public Function NonZeroToTrue( _
ByVal vValue As Variant _
) As Boolean NonZeroToTrue(0) = False
NonZeroToTrue(1) = True
NonZeroToTrue(345) = True
NonZeroToTrue("0") = False
NonZeroToTrue("345") = True
NonZeroToTrue("Word") = False
NonZeroToTrue(Null) = FalseSee also: FixUpVariantToBooleanMandFn FunctionvValue: The value which is checked to see if it is True. vValue can be a number, a date, a numeric string, or a date string. Function returns False if vValue is Null or cannot be fixed up to a number or date.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.