Calculations on Form have stopped working

[ptaylor-west]

I have a calculations on a form that add up different objects on the form ie: =[Handling Charge]+[Packing]+[Delivery Cost] to give me a sub-total then further similar calculations and then finally adding the totals togther, it all worked very well but for some reason they have stopped doing hte calculations.......you can see all the formula's in the objects and I've trebled checked them but no joy...I must have done something to the form as a whole to suspend the calculations but I don't know what....any ideas please?

 

[Jack Cowley]

Hmmm. An interesting problem. I might suggest creating a form, using the Wizard so it goes quickly because looks do not matter at the moment, using the same table or query as the current form that is not giving you answers. Put in an unbound field and put in your calculation and see if it works. If it does then your current form may have gone south on you. That is the only thing that comes to mind at the moment. If that does not work, please feel free to email me directly and I will try and help you find a solution.

And thank you for your kind words in your previous answer. They are sincerely appreciated!

Jack

[This message has been edited by Jack Cowley (edited 09-17-2000).]

 

[Richie]

Just another thought is there a null value in there somewhere?

 

[ptaylor-west]

Thanks for pointing me in the right direction with the Zero/Null point......what I had done after I put in the calculations was take out the default 0 (Zero's) in the fields for easier data imput and so I needed to use the Nz function at the start of my expression to stop the expression returning Null............not that I'm getting good at this, I just remembered seeing that tip in the Help section......lucky.

Thank you both very much for your help once again.

Paul