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

Blank To Null Function
Convert Values Class

Public Function BlankToNull( _
    ByVal vValue As Variant _
    ) As Variant

Replace an empty string with a Null value.
Leave all other types of values unchanged.

    IsNull(BlankToNull("")) = True
    IsNull(BlankToNull(Null)) = True
    IsNull(BlankToNull("Word")) = False
    IsNull(BlankToNull(45)) = False
See also:
    BlankToValue Function
    NullValue Property
vValue: The value which is to be changed from an empty string to a Null if appropriate. Function returns Null if vValue is an empty string. Function returns vValue unchanged in all other cases.

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