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