Error searching in calculated field

[henkus]

Hello,

I have a contionous form with a bunch of textboxes with sum-formulas in the footer (example: "=Sum([PlanAmount])". This has worked like a charm for a long time. After adding a few more sum-boxes, suddenly all the boxes display "#Error", even the ones that worked before. If I remove all new sum-boxes, the old ones work again. I've tried to check the new ones for errors, but it's not exactly obvious (long formulas). How do you guys error-search in this situation? I'm quite new to Access, but my general feeling is that I get very vague feedback from the program on what's really wrong. Am i missing some part of the program which would make these situations easier, or doing something else in a stupied way?

Let me know if more detailed info is needed for relevant feedback!

/henkus

 

[MStef]

Send a short example of MDB. (Access 2000 or 2002).

 

[henkus]

I'm not so much asking for guidiance for this specific problem (I can delete on textfield at a time, thus eventually finding the incorrect one, checking the code and fixing it). I'm more asking in general how you error-search in a more effective way in the graphic part of Access. It's so much easier in the VB-part, as you can dubug the code...

 

[boblarson]

I like to use the free V-Tools tool Total Deep Search which will find things on your forms, on reports, in code, in macros, etc.

You can get it free here:
http://www.skrol29.com/dev/en_vtools.htm