Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Keep It Simple Stupid Keep It Simple Stupid is offline
external usenet poster
 
Posts: 1
Default Calculation in form field

I have created a form (that will be filled out differently every time). The
form is protected.
Within the form, there is a table with 3 columns:
Unit Price - Quantity - Total
I need the Total column to automatically calculate (UnitPrice X Quantity)

There is a form field in the first two columns for the user to enter
numbers.

I have tried putting a form field in the Total Columns as a calculation
(=A2*B2), but it only calculates the first time. In other words, if I "blank
out"or change the number in the Quantity column or the Unit Price, the total
doesn't update.

How can I get this to work?
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Calculation in form field

Have you checked the "Calculate on exit" box for all the fields that
contribute to the calculation? Note, however, that this may be triggered
only by tabbing out of the box, not just by moving the mouse.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Keep It Simple Stupid" wrote
in message ...
I have created a form (that will be filled out differently every time).

The
form is protected.
Within the form, there is a table with 3 columns:
Unit Price - Quantity - Total
I need the Total column to automatically calculate (UnitPrice X Quantity)

There is a form field in the first two columns for the user to enter
numbers.

I have tried putting a form field in the Total Columns as a calculation
(=A2*B2), but it only calculates the first time. In other words, if I

"blank
out"or change the number in the Quantity column or the Unit Price, the

total
doesn't update.

How can I get this to work?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Form Field Calculation JohnS Microsoft Word Help 5 December 21st 06 01:16 AM
Calculation form field won't update Impecunious Microsoft Word Help 8 November 27th 06 03:09 PM
Having trouble with a "If, Then" calculation in a form field, Please Help! jlawson Microsoft Word Help 3 July 7th 06 12:16 AM
Variable in Form Field Calculation? TDMedia Microsoft Word Help 4 April 15th 06 09:24 AM
Word 2000 form field calculation HELP!! Sochinski New Users 2 January 11th 05 02:13 PM


All times are GMT +1. The time now is 12:24 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"