#1
|
|||
|
|||
Legacy Form Fields Miscalculate
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thank you
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Grammar check into legacy forms > Text form field. | Eduardo Care | Word | 2 | 09-09-2015 03:11 PM |
legacy Form Field | sunrise06 | Word | 9 | 05-02-2015 06:48 PM |
Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
Focus wonky in my legacy form fields/table | CindyHa | Word | 8 | 01-13-2015 05:37 PM |
Form Fields - Create blank form text field with if statement? | LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |