Functions returning Nulls

[rorymurray]

How do you deal with a function returning a null value? I know PL/SQL has a function nvl() that can put something in place of a null if null is returned. Does VBA have anything like that?

 

[ide]

ps=null
If IsNull(ps) Or IsEmpty(ps) Then
ps = 0
End If

 

[ide]

or
Nz(variant[, valueifnull])
You can use the Nz function to return zero, a zero-length string (" &quot, or another specified value when a Variant is Null. For example, you can use this function to convert a Null value to another value and prevent it from propagating through an expression.

 

[logius]

You might also try the

IS Nothing

test.

If nvl IS NOTHING Then
    MsgBox "Daaaa... I got nothing!"
    nvl = 0
End If

----------------------------------------
If you are reading this, then you have read too far...

lightwarrior@hotmail.com