| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Calculation in a table in a protected form
Hello,
What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculation in a table in a protected form
Do you have "Calculate on exit" checked in the Form Field Options for every
field that contributes to the calculated field? -- 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. "Claud" wrote in message ... Hello, What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
|
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculation in a table in a protected form
Thank you so much Suzanne. I only had the "calculate on exit" property set
for the "Total cost" field and didn't realize that all the fields referenced in the formula (Qty and Price) had to have it enabled also. Thanks was so helpful! Thanks again. -- Claud "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" checked in the Form Field Options for every field that contributes to the calculated field? -- 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. "Claud" wrote in message ... Hello, What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
|
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculation in a table in a protected form
"Calculate on exit" is a misleading term; "update on exit" would be more
accurate, since many of the uses of the field have nothing to do with calculation, as when there is a REF field referring to the bookmark of a text form field; checking "Calculate on exit" ensures that the REF field updates automatically. -- 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. "Claud" wrote in message ... Thank you so much Suzanne. I only had the "calculate on exit" property set for the "Total cost" field and didn't realize that all the fields referenced in the formula (Qty and Price) had to have it enabled also. Thanks was so helpful! Thanks again. -- Claud "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" checked in the Form Field Options for every field that contributes to the calculated field? -- 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. "Claud" wrote in message ... Hello, What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
|
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculation in a table in a protected form
You're right about ït being misleading. Also, I couldn't find any reference
to that using Help. Still on the subject of calculating formulas in a Word Table, is there any way we can find the cell reference (A1, B1, C1 etc.)? When creating forms, you merge and split cells all the time and you lose track of the columns and rows. Thanks again. -- Claud "Suzanne S. Barnhill" wrote: "Calculate on exit" is a misleading term; "update on exit" would be more accurate, since many of the uses of the field have nothing to do with calculation, as when there is a REF field referring to the bookmark of a text form field; checking "Calculate on exit" ensures that the REF field updates automatically. -- 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. "Claud" wrote in message ... Thank you so much Suzanne. I only had the "calculate on exit" property set for the "Total cost" field and didn't realize that all the fields referenced in the formula (Qty and Price) had to have it enabled also. Thanks was so helpful! Thanks again. -- Claud "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" checked in the Form Field Options for every field that contributes to the calculated field? -- 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. "Claud" wrote in message ... Hello, What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
|
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
|
Calculation in a table in a protected form
See http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm
http://gregmaxey.mvps.org/Table_Cell_Data.htm -- 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. "Claud" wrote in message ... You're right about ït being misleading. Also, I couldn't find any reference to that using Help. Still on the subject of calculating formulas in a Word Table, is there any way we can find the cell reference (A1, B1, C1 etc.)? When creating forms, you merge and split cells all the time and you lose track of the columns and rows. Thanks again. -- Claud "Suzanne S. Barnhill" wrote: "Calculate on exit" is a misleading term; "update on exit" would be more accurate, since many of the uses of the field have nothing to do with calculation, as when there is a REF field referring to the bookmark of a text form field; checking "Calculate on exit" ensures that the REF field updates automatically. -- 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. "Claud" wrote in message ... Thank you so much Suzanne. I only had the "calculate on exit" property set for the "Total cost" field and didn't realize that all the fields referenced in the formula (Qty and Price) had to have it enabled also. Thanks was so helpful! Thanks again. -- Claud "Suzanne S. Barnhill" wrote: Do you have "Calculate on exit" checked in the Form Field Options for every field that contributes to the calculated field? -- 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. "Claud" wrote in message ... Hello, What do I need to do to have a table update values in a protected form? I set the formulas in the "Text Form Field" properties, but it doesn't seem to update the values. I'm trying something simple, i.e., multiply the "Qty" by the "Price" columns and show the result in the "Total Cost". Appreciate your help. -- Claud |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table in Protected form? | Microsoft Word Help | |||
| Form Generaters in Word | Microsoft Word Help | |||
| How do I create a multiplication calculation in a protected form? | Microsoft Word Help | |||
| Automatic update of calculation fields in a protected form | Tables | |||
| Table Format Style vs. Table Text Style | Page Layout | |||
Linear Mode
