View Single Post
  #7  
Old March 27th, 2006, 07:45 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default Adding numbers in a table with text fields

Suzanne,

Thanks for your feedback. I formatted the table just as you discussed and
it still would not work. Out of desperation I decided to delete the entire
table and recreate it. When I did that, everything worked as you said it
would. Evidently there was some quirky formatting miscue in the original
that I could not find to correct.

Bottom line is that the table works properly now. Thanks again!

Zonkeraz

"Suzanne S. Barnhill" wrote:

The way this works is that you create a text form field for each number that
contributes to the calculation. You check "Calculate on exit" for that
field. This guarantees that the calculation field will be correct. For the
rest, see “WD2000: Calculation in Form Field Shows Wrong Result” at
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.

"Zonkeraz" wrote in message
...
They are "Text Form Fields" that I will just enter numerical values, they

are
not formulas themselves.

I think I have partially solved the problem. I went into the "Properties"
of the text fields and made sure the "type" is set to "number". I then
unchecked the "calculate on exit" box. This seemed to work because when I
typed in the value "1" in each text field, the formula worked correctly

and I
got "5" as my answer.

One problem remains: When I go back to clear the text fields, the formula
still shows a value of "5", not "0" like I want it to. When I put in new
numbers in the text fields, they get added to the "5".

How do I get the formula to return to a value of "0" when the text fields
are emptied?

"Zonkeraz" wrote:

I have a Table in Word 2002 that has text fields for entering values. I

want
to enter a SUM formulaat the bottom of the table to add the values. The
formula does not work correctly. I tested it by entering the value "1"

in
each text field. Instead of having the SUM formula show 1..2..3..4..5

as I
enter each "1", it shows 1..3..6..10..16. Each time I tab or move

between
the text fields, the formula changes the value, whether I enter a number

in
the text field or not.

What am I doing wrong?