Automatically Update Form Text Fields

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

Guest

I am preparing a form in Word. I have a table and the last row i want to sum
the rows above. I am using a form text field calculation to do this. i have
"checked" the box on every field that says calculate on exit. when i protect
the form and input numbers the formula does not update. i am totally out of
ideas on how to fix this and have been searching the online help for some 4
hours.

i have other forms that i have written and used this exact method and they
all work on my pc. i did not originally construct this form.

i was wondering if there is some property that may have been disabled in
this document that may be causing the problem....

i would appreciate any help on this as i am desperate
 
Check a) that all the cells actually contain numbers, as opposed to text
masquerading as a number, and b) that there are no empty cells above the SUM
field. This was, I think, fixed in W2003, but earlier versions add upwards
only until there is an empty or non-numeric cell -- all numbers above that
are ignored.
 
I don't think it's fixed even in Word 2003.

--
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.
 
There's probably more to it, but W2003 does cope with any number of
empty/non-numeric cells *immediately* above the SUM() field -- the numbers
above THAT are summed, up to the next empty/non-numeric cell.
 
Back
Top