The information in this article applies to:
SYMPTOMS
When a form field calculation involves another calculated form field, the
results may be incorrect.
Scenario 1: No Formatting in the Number Format of a Form Field
This results in doubling the value of form field 2 (Text2).
Scenario 2: Dollar Sign on Either or Both Form Fields
This results in doubling the value of form field 2 (Text2).
CAUSEWord defines the bookmarks assigned to the calculation form fields incorrectly. As a result, Word does not correctly parse these form fields; it concatenates them instead. WORKAROUNDTo work around these problems, use the method appropriate for your situation. Method 1: Avoid Referring to Any Other Calculation FieldsChange the final calculation to avoid referring to any other calculation fields. Include all math formulas in one calculation field. This method is only appropriate for simple calculations.In the earlier example, because the third form field includes a formula from the second form field, the entry in the third form field expression would need to be changed to: Text1 (Bookmark from the first form field) + Text1 (Expression from the second form field). Method 2: Redefine the Bookmarks So Word Calculates the Formula CorrectlyNOTE: You must repeat this procedure each time you change a particular form field in the Text Form Field Options dialog box.To redefine the bookmarks so Word calculates the formula correctly, use these steps with each incorrect Calculation form field:
Method 3: Define a New Bookmark That Includes the First Calculation FieldNOTE: You do not need to repeat this procedure if you change the form field in the Text Form Field Options dialog box.To define a new bookmark that includes the first Calculation field in your formula plus one space following it, follow these steps:
Method 4: In a Table, Use Table Cell References Rather Than Bookmark NamesUse table cell references rather than bookmark names in the Calculation form field.NOTE: This method works only if there are no other Number form fields in any table cell you reference in your Calculation form field. For example, change this calculation {FORMTEXT {=Text1 + Text2}}to the following {FORMTEXT {=A1 + A2}}where the Text1 bookmark is in table cell A1 and the Text2 bookmark is in table cell A2. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Additional query words: append appends
Keywords : kbdta kbfield word97 |
Last Reviewed: August 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |