atw: Re: Word 2003 Form - Calculation result not displayed automatically
- From: "Diana Muzrimas" <Diana.Muzrimas@xxxxxxxxxxxxxxxx>
- To: <austechwriter@xxxxxxxxxxxxx>
- Date: Fri, 15 Jul 2005 16:26:54 +1000
Thanks Robyn.
That works. (I had not enabled Calculate on exit on a couple of the
fields).
Unfortunately, though I still can't get some fields to calculate (See 6,
7 and 8 in following).
Value1 (enter $, Calculate on exit)
Value2 (enter Number, Calculate on exit)
Value3 (Calculate =Value1*Value2) <<This works (total displays>>
Value4 (enter $, Calucate on exit)
Value5 (enter $, Calucate on exit)
Value6 (Calculate =Value3+Value4+Value5) <<This doesn't work>>
Value7 (Calculate =Value6*10%) <<This doesn't work>>
Value8 (Calculate =Value6-Value7) <<This doesn't work>>
Also tried, Calculate =SUM(Value3,Value4,Value5)
Diana
Canberra
Work 02 6245 2100
Home 02 6241 2381
-----Original Message-----
From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Robyn Richards
Sent: Friday, 15 July 2005 2:28 PM
To: austechwriter@xxxxxxxxxxxxx
Subject: atw: Re: Word 2003 Form - Calculation result not displayed
automatically
Diana,
I'm not sure how you created your form but I just set up a sample form
with
the following:
Text1 (text entryfield, set to accept numbers, fill-in enabled checked,
Calculate on exit checked)
Text2 (text entryfield, set to accept numbers, fill-in enabled checked,
Calculate on exit checked)
Text3 (text entryfield, set as Calculation field, Expression
=Text1*Text2)
(created initially as a template, the form locked and then a document
created from the template)
On completing either Text1 or Text2 (and pressing tab to move to next
field), the value in Text3 updates.
HTH,
Robyn
>From: austechwriter-bounce@xxxxxxxxxxxxx
>Reply-To: austechwriter@xxxxxxxxxxxxx
>To: <austechwriter@xxxxxxxxxxxxx>
>Subject: atw: Word 2003 Form - Calculation result not displayed
>automatically
>Date: Fri, 15 Jul 2005 12:14:42 +1000
>
>Can someone tell me the likely causes why my Calculate field doesn't
>display the outcome of my calculation in my Word 2003 Form?
>
>If I unlock the form, and F9 to update the field the correct total
>displays. But it doesn't display when the User enters numbers in the
two
>bookmarked fields. The formula is =bookmark01*bookmark02.
>
>At present it is just a Word document (not a template), as it is going
>to be emailed to clients for entry, and I thought it would become to
>complicated to use a template.
>
>Any suggestions would be appreciated, as I'm running out of research
>time.
>
>Diana
>TOWER Software
>Canberra
>**************************************************
>To post a message to austechwriter, send the message to
>austechwriter@xxxxxxxxxxxxxx
>
>To subscribe to austechwriter, send a message to
>austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject
field.
>
>To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
with
>"unsubscribe" in the Subject field.
>
>To search the austechwriter archives, go to
>www.freelists.org/archives/austechwriter
>
>To contact the list administrator, send a message to
>austechwriter-admins@xxxxxxxxxxxxx
>**************************************************
**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx
To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject
field.
To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
with "unsubscribe" in the Subject field.
To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter
To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************
**************************************************
To post a message to austechwriter, send the message to
austechwriter@xxxxxxxxxxxxxx
To subscribe to austechwriter, send a message to
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.
To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
"unsubscribe" in the Subject field.
To search the austechwriter archives, go to
www.freelists.org/archives/austechwriter
To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************
Other related posts: