Function Convert Values Class

NullToBlank

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

Signature (Visual Basic / VBA)

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

Code Example

    NullToBlank(Null) = ""
    IsNull(NullToBlank(Null)) = True
    NullToBlank("Word") = "Word"
    NullToBlank(123456) = 123456

Parameters

Parameter Description
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.