I have this function:

Public Function RoundUp(number As Double, significant As Integer) As Double

    RoundUp = Round(number, significant)

    If RoundUp < number Then
        RoundUp = RoundUp + (1 / (10 * significant))
    End If

End Function

The problem is that when a txtA has a Null value then txtB = RoundUp([txtA],2) = #ERROR, instead of #ERROR I will like it to be Null too. I have tried the NZ function but it doesn't converts #ERROR to Null.

Please help.
Thanks

Try this...

txtB = iif(isnull(txtA), Null, RoundUp([txtA],2)

I think that should work, if not let me know and we can try and figure something else out.

Mike

Mike
EchoVue.com

mjuliao,
It looks like textbox B needs textbox A's value so it can calculate its own value?

Did you try using NZ against txtA and putting the result into a variable? Use NZ when you take the value OUT of a control to force the value to either "" if it is a string or 0 if a numeric. You'll probably want to set the format of the txtbox to "general number" so your user doesn't enter text and create other problems with your function).

HTH,

LOralee