Calculate on entry

[Danielh]

I have made an invoice template with form fields
On every row with an item I have a form field that calculates the product of number of items and the item's price to a total price
I have like 30 rows and don't use all the rows every time
But wether I use the row or not the formula will calcute
So my problem is that I'll get several rows showing $0,00 with no items on it
Those rows should be empty with no calculation
I want the formula to start calculate when I make an entry on one of the cells that the formula calculates on
Is this possible

Thank you for your answer

 

[Charles Kenyon]

The fields that are the source for the calculations should be have the
property of "calculate on exit" checked. This is poor phrasing and should
mean "calculate any fields that use this information in their calculation
when exiting from this field."

What you are talking about is what Word calls an "online form." Check this
in help. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles.

Hope this helps,

I have made an invoice template with form fields.
On every row with an item I have a form field that calculates the product

of number of items and the item's price to a total price.

I have like 30 rows and don't use all the rows every time.
But wether I use the row or not the formula will calcute.
So my problem is that I'll get several rows showing $0,00 with no items on it.
Those rows should be empty with no calculation.
I want the formula to start calculate when I make an entry on one of the

cells that the formula calculates on.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RGFuaWVsaA==?=,

Which version of Word are you using?

In the one I currently have running, setting up the calculation form field in an IF field
wokrs to suppress the display of a particular result. For example

{ IF "{ FORMTEXT { =Text1*Text2 }}" = "SFr. 0.00" "" "{ FORMTEXT { =Text1*Text2 }}" }

Use Alt+F9 to display the field codes; Ctrl+F9 to insert an pair of empty field brackets.

I have made an invoice template with form fields.
On every row with an item I have a form field that calculates the product of number of

items and the item's price to a total price.

I have like 30 rows and don't use all the rows every time.
But wether I use the row or not the formula will calcute.
So my problem is that I'll get several rows showing $0,00 with no items on it.
Those rows should be empty with no calculation.
I want the formula to start calculate when I make an entry on one of the cells that the formula calculates on.
Is this possible?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in the
newsgroup and not by e-mail

 

[danielh]

Thanks Cindy!
That really worked!

Thanks to you to Charles

/Danielh

"Cindy M -WordMVP-" skrev: