Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Form Field Calculation | Microsoft Word Help | |||
Calculation form field won't update | Microsoft Word Help | |||
Having trouble with a "If, Then" calculation in a form field, Please Help! | Microsoft Word Help | |||
Variable in Form Field Calculation? | Microsoft Word Help | |||
Word 2000 form field calculation HELP!! | New Users |