View Single Post
 
Old 10-23-2022, 01:59 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by kcaron View Post
This is good information! I have downloaded both documents. Lots of good reference material, but I can't find anything on being able to determine if the field changed or how to change several other fields because this one changed.
The functionality you seek is built into Word itself. And, as I clearly said:
Quote:
Originally Posted by macropod View Post
All these calculations can be done using field coding and having the 'calculate on exit' property set for each of the input formfields
Quote:
Originally Posted by kcaron View Post
what happens if the user overrides the field that is being calculated?
In a document with 'filling in forms' protection applied - which is required when using formfields - what you describe simply isn't possible unless one breaks the document into Sections and leaves Section containing the formula fields unprotected. In Sections of a document with 'filling in forms' protection applied, only the form fields (not any formula fields or other fields) are accessible for selection or user input.

For a fairly simple demonstration of formfields in action, see: https://www.msofficeforums.com/171152-post2.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote