Calculations in forms

[Chey]

I have a word document that I put the form fields in. I have numbers being
entered in and then I want to calculate at the bottom. I put in another field
and put calculations. Is this the right way? Could someone please guide me?

Thanks
Cheyenne

 

[Suzanne S. Barnhill]

Yes, use a calculation-type form field and be sure to check the box for
"Calculate on exit" for each of the form fields that contributes to the
calculation.

 

[Chey]

How do I get it to calculate though right now I have =text3+text4 but it
calculates 0 even though I have a 5 in text3 and a 4 in text4. Will it not
automatically update itself? That is really what I need it to do?

 

[Chey]

How do I do the macro for entry? Will that update the calculations?

 

[Suzanne S. Barnhill]

Double-click the Text3 formfield to open the Form Field Options dialog and
check the box for "Calculate on exit." Do the same for Text4. Then protect
the form. When you enter data in those two fields, you calculation will be
updated. Note, however, that only a tab out of the field will be recognized
as "exit"; just clicking somewhere else doesn't suffice.

 

[Chey]

Thanks I got it.

Double-click the Text3 formfield to open the Form Field Options dialog and
check the box for "Calculate on exit." Do the same for Text4. Then protect
the form. When you enter data in those two fields, you calculation will be
updated. Note, however, that only a tab out of the field will be recognized
as "exit"; just clicking somewhere else doesn't suffice.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

 

[Graham Mayor]

You would only need a macro to update fields if you were using a Word field
in the header/footer to create or reproduce the calculation. If you were to
need such a macro, you can use the sample code at
http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>