#Error

  • Thread starter Thread starter Danie
  • Start date Start date
D

Danie

I am getting this error #Error in one of my text boxes in a form. This is
what I have in the source :
=Nz([frmJobDetailsSummary].[Form]![txtTLabourCostt]). It seems that I have a
null in my subform but I don't know how to handle this. I tried some If
statements but I still have the same error.

Can somebody help me.
Thanks,
Danie
 
Danie,

If your subform has no records, then no, you don't have a Null, you have
something that doesn't exist, and Nz is not applicable.

You can do it like this:
=IIf(IsNumeric([frmJobDetailsSummary]![txtTLabourCostt]),[frmJobDetailsSummary]![txtTLabourCostt],0)
 
Thanks so much for your help Steve, as in fact I have no records in my
subform and thought it would bring back a Null.

Danie

Steve Schapel said:
Danie,

If your subform has no records, then no, you don't have a Null, you have
something that doesn't exist, and Nz is not applicable.

You can do it like this:
=IIf(IsNumeric([frmJobDetailsSummary]![txtTLabourCostt]),[frmJobDetailsSummary]![txtTLabourCostt],0)

--
Steve Schapel, Microsoft Access MVP


Danie said:
I am getting this error #Error in one of my text boxes in a form. This is
what I have in the source :
=Nz([frmJobDetailsSummary].[Form]![txtTLabourCostt]). It seems that I
have a
null in my subform but I don't know how to handle this. I tried some If
statements but I still have the same error.
Click to expand...
Click to expand...
 
Back
Top