#Error

[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

 

[Steve Schapel]

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)

 

[Danie]

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

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

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.