Word 2010: How to update a formula value automatically

I am building a form template with several scoring fields.
At the end I would like to have a scoring total.

I did this by using bookmarks withing the different scores, and then a formula summarizing those bookmarks.
It works as expected.

But can't I make this total field be automatically updated?
Do I need to go there and update the field?


This is one area unfortunately where WordPerfect beat Word hands down :-(.  Despite having the perfect vessel for it for over 5 years (the content control), Microsoft has yet to provide a functional "change" event to perform this function:

 

(CC1 content = 1  + CC2 content = 1)  = CCSum content = 2

 

Change CC1 content to = 2 and CCSum content should automaticall change to = 3 

 

You can get close with the methods shown here: http://gregmaxey.mvps.org/word_tip_pages/content_controls_use_in_math_operations.html

but to do so, you must first "Exit" the variable CC.

 

You can even make it automatic using a custom change event but it is complicated and involves a lot of overhead:  http://gregmaxey.mvps.org/word_tip_pages/content_control_custom_events.html

 

Hopefully one day MS will fully realize and exploit the capabilities of CCs.

 

All that said, you do have to update the field.  But you don't "have to go there."  I don't know what type of fields you are using, but you might be able to use the exit event from the fields, or simply toggle to print preview which should update fields.

 

Greg Maxey
***
Death smiles at us all, but all a man can do is smile back.


For more help with Word visit:
http://gregmaxey.com/word_tips.html

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

If you are using legacy form fields, then checking the box for "Calculate on exit" in each form field included in the total should result in the total being updated automatically.
Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated January 2, 2025 Views 6,093 Applies to: