How to avoid #Num! being displayed?

[path479]

I have a text box and its control source is an expression as follow:

=[txtPrimaryWkpt_area]/[txtNLA]

When the value is Null, it is displaying "#Num!"

I have tried adding Nz around the expression to become

=Nz([txtPrimaryWkpt_area]/[txtNLA], 0)

However it makes no differences.

What is the best way to avoid the textbox displaying #Num!? Displaying as blank or 0 are both acceptable

 

[arnelgp]

=Nz([txtPrimaryWkpt_area], 0) /Nz([txtNLA], 1)

 

[path479]

Hi arnelgp,

Thank you for your suggestion. Unfortunately "=Nz([txtPrimaryWkpt_area], 0) /Nz([txtNLA], 1)"does seem to work.

I ended up using the following
=IIf([txtNLA]=0,0,[txtPrimaryWkpt_area]/[txtNLA])