Calcuation fields in Tables

[Jack_Feeman]

HI, need to tap on your expertise for a second. Word 2003 Form.

• Have two columns of dollar amounts in a Word Table. These are each
bookmarked with an unique name from within the form field properties dialog
box.

• Each column ends with a calculation field summing the total of the column
(done referencing each of the unique bookmarks above. The first column
summary field is bookmarked as "ASSETS" and the second as "DEBITS". These
bookmarks were assigned to the cell since the Word field edit box does not
have a place to assign a bookmark to the field.

• Then there is a Networth calculation field (ASSETS-DEBITS) which should be
calculated each time ASSETS or DEBITS is changed.

How do I get the NETworth field to (re)calcuate the ASSETS-DEBITS amount
each time any of the amount in the table changes since the Word Field
(Formula field) edit box does not have a calculate on exit toggle as the form
fields do?
(As the user tabs through the form filling in the amounts, the column Sum
fields work great but the Networth fields does no calculations at all since
the tabbing bypasses these calculation fields completely?)

Thanks Jack

 

[Jack_Feeman]

Almost forgot, since this form will go outside the company, I can not use any
macros that would require the user to set their macro security to medium if
already set to high. Thanks

 

[Peter Jamieson]

Try the following:

1. Instead of bookmarking your cell as ASSETS, create a text form field in
the cell and set its properties as:
Type: Calculation
Expression: the = formula you need to use to calculate the ASSETS value
Bookmark: Assets

2. Do the equivalent thing for DEBITS

3. Do the equivalent thing for the cell(or whatever) where you need the
Assets-Debits calculation.

Peter Jamieson

 

[Jack_Feeman]

Thanks Peter, will give it a try. The columns spread over two pages so the
"=SUM(ABOVE)" formula did not seem to include the cells in the column on the
previous page so I switched to calling out each cell by bookmark. Thanks
again for such an expeditious reply.