adding fields

D

Dan

i have a form where i have like 5 text form fields i
would like the total at the end to add these numbers up
automatically for example i key in

$25
$50
$35

and i want the last field to automatically tally these up
after i enter each one is this possible ?
 
G

Graham Mayor

Dan said:
i have a form where i have like 5 text form fields i
would like the total at the end to add these numbers up
automatically for example i key in

$25
$50
$35

and i want the last field to automatically tally these up
after i enter each one is this possible ?

Set the form field properties as number with the dollar format set in the
number format section.
In addition set the calculate on exit check box in the last of the three
fields.
Add a fourth field and set its properties as a calculation field and set the
calculation as =Text1 + Text2 + Text3 and again the number format as the
dollar format. Lock the form and when you tab out of the third field the
fourth will display the required calculation.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top