Programming Reference Manual

IfNull

Syntax

expr IfNull(expr [, NullReplacement])

Description

Returns a replacement value when the tested expression is empty or has a null value.

Parameter	Description
expr	Expression to be evaluated
NullReplacement	Optional. Replacement value in case expr is null or empty. Default value is 0 (zero).

See Also

IsEmpty, IsNull.

Example

 
Sub Main
    Dim X As Variant
    Debug.Print ifnull(X, "not assigned")
End Sub