form field auto calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
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/Customization/FillinTheBlanks.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


--------- --------- --------- --------- --------- ---------
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.
 
Back
Top