Using tables and formulas

[Diane Dennis]

Hi!

I've created a purchase order form in Word X Service Release 1 and I'm
trying to get the "total" column to multiply the "quantity" and "unit
price" and enter the answer in the "total" column. (The reason the
form is in Word is because my customer requested Word rather than
Excel)

I clicked in the cell that I wanted the total to appear and went to
Table > Formula > and entered the following formula:

=(Text11)*(Text12) \# "$#,##0.00;($#,##0.00)"

"Text11" is the form field I created in the "Quantity" column and
"Text12" is the form field I created in the "Unit Price" column.

"Text11" is Type: Number and Number Format: 0
"Text12" is Type: Number and Number Format: \# "$#,##0.00;($#,##0.00)"

When I lock the form and then enter a quantity in "Text11" and a unit
cost in "Text12", the calculation does not work, the total remains
$0.00.

When I unlock the form the same thing happens, the calculation does
not work and the total remains $0.00. However, if I click within the
cell that the total is supposed to show in and then hit F9 the total
changes from $0.00 to be the correct product of Text11 and Text12.

Any ideas what I'm doing wrong or what I'm missing here? How do I get
the calculation to work with the form locked so that my customer can
use it?

As always, thank you so much to everyone who helps here!!

Have a great day!
Diane Dennis

 

[John McGhie [MVP - Word]]

Your form fields need the "Calculate on exit" property set to True so that
Word updates the form whenever the user's cursor leaves either field.

Cheers


This responds to article <[email protected]>,

Hi!

I've created a purchase order form in Word X Service Release 1 and I'm
trying to get the "total" column to multiply the "quantity" and "unit
price" and enter the answer in the "total" column. (The reason the
form is in Word is because my customer requested Word rather than
Excel)

I clicked in the cell that I wanted the total to appear and went to
Table > Formula > and entered the following formula:

=(Text11)*(Text12) \# "$#,##0.00;($#,##0.00)"

"Text11" is the form field I created in the "Quantity" column and
"Text12" is the form field I created in the "Unit Price" column.

"Text11" is Type: Number and Number Format: 0
"Text12" is Type: Number and Number Format: \# "$#,##0.00;($#,##0.00)"

When I lock the form and then enter a quantity in "Text11" and a unit
cost in "Text12", the calculation does not work, the total remains
$0.00.

When I unlock the form the same thing happens, the calculation does
not work and the total remains $0.00. However, if I click within the
cell that the total is supposed to show in and then hit F9 the total
changes from $0.00 to be the correct product of Text11 and Text12.

Any ideas what I'm doing wrong or what I'm missing here? How do I get
the calculation to work with the form locked so that my customer can
use it?

As always, thank you so much to everyone who helps here!!

Have a great day!
Diane Dennis

--

Please respond only to the newsgroup to preserve the thread.

John McGhie, Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs
+61 4 1209 1410, mailto:[email protected]

 

[Diane Dennis]

Thank you John!

Have a terrific day!
Diane

Your form fields need the "Calculate on exit" property set to True so that
Word updates the form whenever the user's cursor leaves either field.

Cheers


This responds to article <[email protected]>,