form field calculation in word

[ArnoldF]

This is a simple example of an error I am getting on a much larger document
with may fields.
On a Word form I have two user-filled-in fields and two calculated fields.
The first calculated field adds the 2 user fields (correctly as =text1+text2)
but the 2nd calc field I just have the formula =text3 (the 1st calc field).
If the user field values are 1 and 2, text3 correctly displays 3 as the
result but text 4 displays 33 instead of 3.
Any suggestions would be appreciated.

 

[Charles Kenyon]

You do not need form fields for this, you can use simple calculation fields.

{ = { Ref text1 } + { Ref text2 } } in your document. You need to be sure
that the property "calculate on exit" is checked for each field that is the
source of information for a calculation. The braces need to be inserted with
Ctrl-F9 or Insert > Field, not simply typed.

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/Customization/FillinTheBlanks.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


--------- --------- --------- --------- --------- ---------
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.

 

[ArnoldF]

Thank you for your response but I am getting the same problem with CTRL-F9
formula. Replacing my form field text4 with {=text3} it still responds with
33 instead of 3. It seems to concatenate the field twice; if text3 was 4 then
the formula responds with 44. If my formula is =text3+text3 I get 66 when
text3=3 and 88 when text3=4.
This problem only happens when I use a formula (or calculation field)
referencing a field that has a calculation in it.

Arnold F