[KobusR]

I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add field 1 and
field 2's data. This must happen of a form I've designed in Word

[Graham Mayor]

Multiply the amount by what?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



KobusR wrote:
I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add
field 1 and field 2's data. This must happen of a form I've designed
in Word

[macropod[_2_]]

Hi KobusR,

You don't need formfields for the calclations - just formula fields. Suppose the formfield into which you insert the number is named
'Text1' and its properties are set to 'calculate on exit'. In that case you can use a formula field coded as:
{=Text1*0.1 \# $,0.00}
to calculate 10% of the formfield's value, and
{=Text1*1.1 \# $,0.00}
to calculate 110% of the formfield's value - which is the same as summing the formfield's value and the 1st calculation's result.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

I advise you not to try to use a formfield to do the calculations the way you've described. When you use the result of a given
formfield's calculation in another formfield, the results in the dependent formfield are unreliable.

--
Cheers
macropod
[MVP - Microsoft Word]


"KobusR" wrote in message ...
I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add field 1 and
field 2's data. This must happen of a form I've designed in Word

[KobusR]

Eg. First form field will have an amount in which can varies
1. $ 540.00
2. 2nd form field must multiply this amount by .14 to work out the tax that
would be payable.(In South Africa)
3. Last form field must have the total of 1. + 2.

"Graham Mayor" wrote:

Multiply the amount by what?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



KobusR wrote:
I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add
field 1 and field 2's data. This must happen of a form I've designed
in Word

[Graham Mayor]

Assume that the form field is Text1, set the type to number with a dollar
format and check calculate on exit check box

Set the two extra form fields as type Calculated and the calculations in the
field properties are

=Text1 * .14

and

=Text1 * 1.14

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



KobusR wrote:
Eg. First form field will have an amount in which can varies
1. $ 540.00
2. 2nd form field must multiply this amount by .14 to work out the
tax that would be payable.(In South Africa)
3. Last form field must have the total of 1. + 2.

"Graham Mayor" wrote:

Multiply the amount by what?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



KobusR wrote:
I want to type an amount in a form field. The next form field must
automatically multiply this amount. The last form field must add
field 1 and field 2's data. This must happen of a form I've
designed in Word