Ask a new question

Update fields in WORD Legacy form fields

I am having an issue getting WORD form fields to update SUM and other function fields, and 'FORMTEXT' calculations. Did something change in WORD (I don't remember ever having so much difficulty setting up a form to auto-calculate on tab-out of the referenced fields.)

Thx!  Doug

In the Text Form Field Options dialog box, select "Calculate on exit" for the relevant fields.
Stefan Blom
MS 365 Word MVP since 2005
Volunteer Moderator
MS 365, Win 11 Pro
~~~
Note that I do not work for Microsoft
https://mvp.microsoft.com/
~~~
Please specify Word version & OS in your question

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.

I know about this option, but I need this form to update 'Live' for my users. Is there any way to coax this form to update once data has been entered?

Thx!  Doug

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.

Have you added the filling-in forms protection?
Cheers
Paul Edstein
(Fmr MS MVP - Word)

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.

"Calculate on exit" plus "Filling in forms" protection should do what you want. Calculation is forced as you tab out of a field (this has been the behavior of form fields since Word 97, possibly in even older versions).

Stefan Blom
MS 365 Word MVP since 2005
Volunteer Moderator
MS 365, Win 11 Pro
~~~
Note that I do not work for Microsoft
https://mvp.microsoft.com/
~~~
Please specify Word version & OS in your question

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.

That's all working for user-entry and select fields that are tabbed into, but none of thecalculated fields that reference these other fields are updating/calculating.  I've never had this problem before so I'm wondering if there's some control for non-tabbed calculated field updating.

Here's one of the 'Calculation' field entries for 'Expression':

=Knowledge1+Knowledge2+Knowledge3+Knowledge4+Knowledge5+Skills1+Skills2+Skills3+Skills4+Skills5+Attitude1+Attitude2+Attitude3+Attitude4+Attitude5

-Where 'Knowledge1' or 'Skills 4' etc. are bookmarks and 'Calculate on exit' is checked. 

Thx!  Doug

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 send me a copy of the document, I will investigate the issue.
Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

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 October 5, 2021 Views 366 Applies to: