Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Hi,
I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Hi Impecunious,
Did you protect the document for forms? "Calculate on exit" won't work if you don't. Cheers -- macropod [MVP - Microsoft Word] "Impecunious" wrote in message oups.com... Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
You don't really need a form field for the calculation - use a Word formula
field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Hi Graham,
It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers -- macropod [MVP - Microsoft Word] "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
I had assumed the '-' to be part of the bookmark name
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Guys,
Thanks for your suggestions. Unfortunately, I get the same result (no automatic update) even after trying a formula reference. My form's in protect mode, and what's worse, I can create a separate "quick and dirty" document with these three fields and the text form field calculation fires fine. Now what? Thanks again. Graham Mayor wrote: I had assumed the '-' to be part of the bookmark name -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Guys,
Thanks to all for your suggestions. Unfortunately, I'm getting the same problem with this reference approach as well - the answer won't update once either one of the supporting fields are modified. By the way, I've tested this with the form in protected mode. Now what? Thanks. Graham Mayor wrote: I had assumed the '-' to be part of the bookmark name -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Try the update macro on exit from the second of the fields -
http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Guys, Thanks for your suggestions. Unfortunately, I get the same result (no automatic update) even after trying a formula reference. My form's in protect mode, and what's worse, I can create a separate "quick and dirty" document with these three fields and the text form field calculation fires fine. Now what? Thanks again. Graham Mayor wrote: I had assumed the '-' to be part of the bookmark name -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculation form field won't update
Interesting... it turns out that my table of contents seems to be the
culprit. If I delete it, the calculation fires away. Now I'm really irritated. This seems like a pretty significant bug. Thanks to all for your help. Graham Mayor wrote: Try the update macro on exit from the second of the fields - http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Guys, Thanks for your suggestions. Unfortunately, I get the same result (no automatic update) even after trying a formula reference. My form's in protect mode, and what's worse, I can create a separate "quick and dirty" document with these three fields and the text form field calculation fires fine. Now what? Thanks again. Graham Mayor wrote: I had assumed the '-' to be part of the bookmark name -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org macropod wrote: Hi Graham, It'd probably work better as: {={REF Bok_Benefit}/{REF Bok_Cost}-1} or: {={Bok_Benefit}/{Bok_Cost}-1} or even: {=Bok_Benefit/Bok_Cost-1} Cheers "Graham Mayor" wrote in message ... You don't really need a form field for the calculation - use a Word formula field instead {={REF Bok_Benefit}/{REF Bok_Cost-1}} Calculate on exit will force an update on such a field (unless it is in a header/footer, when you need a macro run on exit from the field to update it - eg the sample code at http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Impecunious wrote: Hi, I've got a calculation form field in Word that uses the formula '=bok_benefit/bok_cost-1', where bok_benefit and bok_cost are two other bookmarked text form fields. I've set both of these supporting fields to "Calculate on exit", but for whatever reason, my calculation field refuses to update when either of these fields are modified. I can F9 the field and it'll update, but because this document is going to be used as a form, I obviously don't users to have to resort to this. I'm trying to wrap up this form ASAP, and this problem is driving me nuts. I'd definitely appreciate anyone's advice! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select text in form field | Microsoft Word Help | |||
Having trouble with a "If, Then" calculation in a form field, Please Help! | Microsoft Word Help | |||
Drop-Down Form Field and IF Field | Microsoft Word Help | |||
How do I insert "buttons" that I can "X" on a form? | Microsoft Word Help | |||
How can a user change the default date in a form field? | Tables |