Function Convert Values Class

EmptyToBlank

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

Signature (Visual Basic / VBA)

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

Code Example

    Assuming
       Dim varEmpty As Variant
    for example
       EmptyToBlank(varEmpty) = ""
       EmptyToBlank(EmptyValue) = ""
       IsNull(EmptyToBlank(Null)) = True
       EmptyToBlank("Word") = "Word"
       EmptyToBlank(123456) = 123456

Parameters

Parameter Description
vValue The value which is to be changed from Empty to a blank string if appropriate. Function returns an empty String if vValue is an Empty Variant. Function returns vValue unchanged in all other cases.