Thread: adding fields
View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

Dan wrote:
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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org