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

Null To Blank Function
Convert Values Class

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

Replace a Null value with a blank String.
Leave all other types of values unchanged.

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

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