Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Calculating Form Fields.

Calculating Form Fields

by Allen Wyatt
(last updated July 4, 2015)

2

In other WordTips you've learned how you can set up your form fields so that they perform calculations and display the results. (I'm talking about legacy form fields here.) When you print your form, Word updates the fields so that the results of the calculations are displayed in the form. What if you don't want to wait until printing in order to view the results?

Fortunately, Word provides a way you can do this. Make sure you follow these steps:

  1. Unprotect your form so that you can change the options for each field.
  2. Select a form field used in a calculation.
  3. Make sure the Developer tab of the ribbon is displayed.
  4. Click on the Properties tool in the Controls group. Word displays the Options dialog box for the field. (See Figure 1.)
  5. Figure 1. The Options dialog box for a form field.

  6. Make sure the Calculate on Exit check box is selected.
  7. Click on OK.
  8. Repeat steps 2 through 6 for each of the other fields used in your calculations.
  9. Protect the form again.

You can now use the form as normal. Whenever you press Tab to move between fields, and you leave a field used in a calculation, Word recalculates all the fields in the form. The result is that your calculated fields are always updated, as desired.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8517) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Calculating Form Fields.

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

Summing Only Visible Values

When you use SUM to determine the total of a range of values, Excel doesn't really pay attention to whether the values ...

Discover More

Converting European Dates to US Dates

Those in Europe use a date format that is different than those in the US; this is not news. But what if you need to ...

Discover More

Getting the Name of the Parent Workbook

If you need to insert into a cell the name of the workbook in which a worksheet is contained, you can use the CELL ...

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 (ribbon)

Understanding Forms

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

Discover More

Converting Forms to Regular Documents

Word allows you to protect documents that are intended to be used as forms. If you want to convert the form responses ...

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 ...

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. Maximum image size is 6Mpixels. 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 3 + 8?

2016-04-14 16:01:50

SC

This does NOT work for Word 2010. The options box is completely different (e.g., there is no "calculate on exit" choice).


2015-10-08 13:45:38

PF

I tried this option, but it still does not calculate.


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu 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.