text box default value

[ssvec]

I hope this is a no-brainer. I have several fields from 2 subforms that are added together to display totals on the main form. When 1 subform returns no values, the total calculation displays #Error on the main form. Is there a way to get the fields on the subforms to have a default value of zero so that maybe the total calculations will work? There is no "default value" property available on the fields on the subforms, and I am using Access 2000.

 

[THoey]

Instead of filling in a value in the field, use the NZ function in your calculation. If the field has no value, it will make it a zero... Terry M. Hoey

Please read the following FAQ to learn how to help me help you...

faq183-874

 

[ssvec]

Thanks for your reply. I am using the Nz function to return a zero, this is the syntax I am using:
Nz([textbox],0)

 

[ssvec]

and I forgot to add that it is not working..