When I use Word's legacy form textbox fields to calculate, I get an incorrect result if one of the fields referenced in the calculation is also a calculation field.

For example, Let's say that I want these three fields:

1. Text1: Price
No Formula
Type: numeric

2. Text 2: Tax
Formula =Text1*.08
Type: calculation

3. Text 3: Total
Formula =Text1+Text2
Type:calculation

I did a YouTube video on this here if my description makes no sense.

What is happening, is that starting in Word 2007 and for every version since, at step 3, the value from step 2 is doubled.

So if I put $10 in field Text1, I get $0.80 in field Text2 (that's good), but instead of getting $10.80 in field Text3 like I believe I should, I get $11.60, which = 10+80+80. It's adding the "calculation" field twice.

Am I doing something wrong? Is anyone else getting this "double" result?

To get around it, I changed the formula in Text3 to redo all the math: =Text1+(Text1*.08). This works, but can be a big pain in complex formulas that reference multiple calculation result fields and I swear I never had this happen in Word 2003 or older.

What has me doubting my sanity is that this happens to me every time in the newer versions of Word, on many different computers, but I'm not seeing mention of it on the internet.

Please help me!



Many thanks.

This is a long-standing and well-documented bug. Instead of using formfields for the calculations, you should use formula fields. To see how to do a wide range other calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you, Thank you, Thank you!

I knew the formula field existed, but it never occurred to me to use it in a form. Duh! I'm surprised I couldn't find anything on this on the internet, it must have been the way I was wording it.

Well, I am very happy now! Thank you also for the great resources.