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

Moving a Chart's Legend

Need to move a chart legend to a different place on the chart? It's easy to do using the mouse, as described in this tip.

Discover More

Segregating Numbers According to Their Sign

Remember your number line from your early years in school? Some numbers can be below zero (negative numbers) and others above ...

Discover More

Printing a Full Style Sheet

Word supports the use of styles (they are very powerful), but it doesn't provide a way to get a full-featured style sheet ...

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)

Calculating Form Fields

Form fields allow you to create (you guessed it) forms. Here is a description of how you can force Word to calculate the ...

Discover More

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

Stopping Enter from being Pressed In a Form

If you create a form using Word, chances are good that you don't want a user to mess up the layout of the form by pressing ...

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

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 7 + 5?

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 !


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

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.