Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
JSwa
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.docmanagement
Charles Kenyon
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I make a form field autopupulate with text from another field HCFRAdmin Tables 1 January 11th 06 07:30 PM
Spellchecking Locked Bookmarked FormFields Results in LOSS of Book jarimura Microsoft Word Help 15 December 20th 05 05:53 AM
How do I auto copy & paste text from 1 form field to another? Steve W Microsoft Word Help 1 December 16th 05 06:21 PM
Form Field Appearance N. Cotton Microsoft Word Help 3 November 17th 05 05:18 PM
Form Field Formatting Leslie Microsoft Word Help 3 June 14th 05 03:06 PM


All times are GMT +1. The time now is 03:32 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"