Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
form field auto calculate
I'm having some problems with my form fields. I want a form field to
calculate the total from 4 other form fields. I have my equation set as =Text41+Text42...etc. And the totaling works, only when you select the form and hit F9. I want to make this field update the totals automatically, whether the document is locked or unlocked. However, I'm not sure what macro to use. I tried setting it on Run Macro on (in the editing of the form field) both entry and exit or just one or the other. The macro I used was update fields. Then I tried Calculate on Exit instead of Macros. However I tried I could not get the field to update automatically. Is there a way to do this on Word alone? Or is this asking too much from Word? If so could someone please tell me how? Thank you! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
form field auto calculate
See €œWD2000: Calculation in Form Field Shows Wrong Result€
http://support.microsoft.com/?kbid=211253 -- 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. "JSwa" wrote in message ... I'm having some problems with my form fields. I want a form field to calculate the total from 4 other form fields. I have my equation set as =Text41+Text42...etc. And the totaling works, only when you select the form and hit F9. I want to make this field update the totals automatically, whether the document is locked or unlocked. However, I'm not sure what macro to use. I tried setting it on Run Macro on (in the editing of the form field) both entry and exit or just one or the other. The macro I used was update fields. Then I tried Calculate on Exit instead of Macros. However I tried I could not get the field to update automatically. Is there a way to do this on Word alone? Or is this asking too much from Word? If so could someone please tell me how? Thank you! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
form field auto calculate
I don't think it is possible to have something properly update regardless of
whether the form is locked or not. If it is locked and you have "calculate on exit" checked in your source fields (not the calculation result field) it should update when a user tabs out of each field. (It does not update when someone changes the field, but when they exit it.) No macros should be necessary. What you are talking about is what Word calls an "online form." For more about online forms, follow the links at http://addbalance.com/word/wordwebresources.htm#Forms or http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm especially Dian Chapman's series of articles. Hope this helps, -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "JSwa" wrote in message ... I'm having some problems with my form fields. I want a form field to calculate the total from 4 other form fields. I have my equation set as =Text41+Text42...etc. And the totaling works, only when you select the form and hit F9. I want to make this field update the totals automatically, whether the document is locked or unlocked. However, I'm not sure what macro to use. I tried setting it on Run Macro on (in the editing of the form field) both entry and exit or just one or the other. The macro I used was update fields. Then I tried Calculate on Exit instead of Macros. However I tried I could not get the field to update automatically. Is there a way to do this on Word alone? Or is this asking too much from Word? If so could someone please tell me how? Thank you! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make a form field autopupulate with text from another field | Tables | |||
Spellchecking Locked Bookmarked FormFields Results in LOSS of Book | Microsoft Word Help | |||
How do I auto copy & paste text from 1 form field to another? | Microsoft Word Help | |||
Form Field Appearance | Microsoft Word Help | |||
Form Field Formatting | Microsoft Word Help |