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

C Sng Ign Err Function
Convert Values Class

Public Function CSngIgnErr( _
    ByVal vValue As Variant _
    ) As Long

"Convert To Single Ignore Errors"
Attempt to convert vValue to a Single (precision floating-point) value.
Return vValue as a Single value if the conversion was successful.
Return 0 (zero) if vValue could not be converted to a Single.

    CSngIgnErr(34) = 34!
    CSngIgnErr(0) = 0!
    CSngIgnErr(-34) = -34!
    CSngIgnErr(34.3) = 34.3!
    CSngIgnErr("1") = 1!
    CSngIgnErr("0") = 0!
    CSngIgnErr(#12/31/1899#) = 1!
    CSngIgnErr("Word") = 0!
See also:
    CanBeSingle Function
    CDblIgnErr Function
    CCurIgnErr Function
    CSng Function (Visual Basic)
vValue: The value which will be converted to a Single and returned (if conversion is possible). Conversion is not possible if vValue is Null, an Error, an Object, a non-numeric String, or a numeric value out of the range allowed for this data type.

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