Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Field Calculations in Locked Forms.

Field Calculations in Locked Forms

by Allen Wyatt
(last updated March 25, 2015)

2

Kathleen described a problem she had with Word not updating a calculated field in a locked form. For instance, if there are three fields (Field1, Field2, and Field3) that are summed together into another field (Total), then Kathleen could not get the Total field to calculate, even though she set the Calculate on Exit property of the Total field.

The reason the problem occurs is a misunderstanding of the way in which Word calculates form fields; it has nothing to do with the fact that the form is locked. (In fact, the form must be locked in order to fill in the form fields at all.) The problem arises because it is not the Total field that must have the Calculate on Exit property turned on, but the fields on which Total is dependent. In this instance all three contributory fields—Field1, Field2, and Field3—must have their Calculate on Exit property set. If they do, then the Total will update properly (and interactively) as expected.

As a side note, it does very little good to have the Calculate on Exit property set in the Total field. Why? Because when you set the field's Type property to Calculation, enter your formula in the Form Field Options dialog box, and then lock the form, the Total field cannot be selected. If it cannot be selected, you can't exit it (you can't exit what you can't enter), so the Calculate on Exit property is never triggered.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1542) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Field Calculations in Locked Forms.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Hiding Smart Tags

If you don't want to see Smart Tags displayed in your document, you can instruct Word to hide them. Here's how to make the ...

Discover More

Enforcing a Do-Not-Use Word List

Got a list of words you don't want to appear in your documents? There are a number of ways that you can make sure they don't, ...

Discover More

Modifying Behavior of the Open Dialog Box

The Open dialog box is one that few of us think about, but you can control how it behaves with a little bit of macro coding. ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

MORE WORDTIPS (MENU)

Saving and Using a Form

After you have created your custom form, you will need to save it so that you can use it as often as needed. Word makes this ...

Discover More

Understanding Forms

If you have ever created several documents that contain the same basic information with only a few minor differences, then ...

Discover More

Protecting Parts of a Document

Word doesn't require you to protect entire documents. Instead, you can protect different sections within a document, as ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 + 8?

2016-02-23 15:22:03

Lori Edwards

I have a protected document with Calculated fields. I have Calculate on Exit set for all fields that the calculated field is calculating and it still will not calculate on exit of any field before or after the calculated field.


2013-04-17 10:58:07

Micha

Thanks a lot. I learned something today !

Actually to overcome this problem, I had created a macro on my template, but when passing the template to others, the macro did not get passed over for some reason.

Thanks again !


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share