Calculation in Form

[Guest]

Hi! I have read all the posts on this topic, as well as scouring MVP sites
but I can't find the answer to this question. I am trying to update a field
in a locked form after user input. Column A has text; Column B has Text Form
Field for Number input times 3 rows.

Row 4B, has Text Form Field (Calculation); =SUM(B4:B6) and calculate on
exit. It works when I close the form and then re-open or re-do this
instruction, but it won't update when the form is in input mode (locked).

I have tried bookmarks. Can't use macros because the server that the form
must go on, will disable macros. Can you come up with a solution? I'm using
Word 2003.

Tx, Gadgetmumma

 

[Graham Mayor]

At the place where you want the result of the calculation insert the
following field construction

{=({Text1} + {Text2} + {Text3})}

where Text1-3 are the bookmarked names of the three form fields and the
field boundary pairs are all inserted with CTRL+F9. Check the calculate on
exit ext boxes of those form fields. Note that you will get an error until
all three fields are filled.

You really should speak to your IT support about the wisdom of crippling the
most powerful part of Word - the macros.


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

My web site www.gmayor.com

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