WD97: How to Modify a Calculation Field to Appear Blank

MORE INFORMATION

If You Use a Formula (=) Field

1. Press ALT+F9 to toggle (show) the field codes.
   
   You should see a formula field similar to the following:

   { =SUM(A1:A3) \# $#,##0.00 }

2. Change (modify) the formula field to resemble the following:

   { =SUM(A1:A3) \# $#,##0.00;($#,##0.00); }

   NOTE: Be sure to include (type) the semicolon at the end of the picture switch.
3. Press ALT+F9 to toggle (hide) the field codes and to show the result of the formula field. When you update your field codes, the formula field should now appear blank when the result of the calculation is zero.

If You Use a Calculation Form Field

1. Unprotect your form document.
2. Double-click the Calculation form field.
3. In the "Text Form Field Options" dialog box, copy (CTRL+C) or cut (CTRL+X) and then delete the contents of the Number format box.
   
   NOTE: The Number Format box must be blank.
4. In the "Text Form Field Options" dialog box, paste or type the number format to the end of the formula contained in the Expression box.
   
   The Expression box should appear similar to the following example:

   =text1 + text2 \# $#,##0.00;($#,##0.00);

   NOTE: Be sure your expression ends with a semi-colon (;).
5. Click OK to close the "Text Form Field Options" dialog box, and then reprotect your form.

1. Unprotect your form document.
2. Double-click the Calculation form field.
3. In the "Text Form Field Options" dialog box, copy (CTRL+C) or cut (CTRL+X) and then delete the contents of the Number format box.
   
   NOTE: The Number Format box must be blank.
4. Click OK to close the "Text Form Field Options" dialog box.
5. In your form, press ALT+F9 to toggle (show) the field codes.
   
   The calculation text form field should disappear and show a field similar to the following:

   { FORMTEXT { =PRODUCT(A1:A3) } }

6. Paste (CTRL+V) or type the picture field switch (\#) format for your FORMTEXT field to show as follows:

   { FORMTEXT { =PRODUCT(A1:A3) \# $#,##0.00;($#,##0.00); } }

   NOTE: Be sure to include (type) the semicolon (;) at the end of the picture switch.
7. Press ALT+F9 to toggle (hide) the field codes and to show the result of the Calculation Text Form Field, and then reprotect your form.