Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am making a form with the "Text Form Field" button (from the Forms
Toolbar). In some boxes I am entering text. In some I am entering numbers. Is it possible to have a box at the end of the document (ie. a "Total Amount" box) that will have automatically added the numbers from specific boxes together? Word 2002 (sp3), Win XP Thank you. Nick |
#2
![]() |
|||
|
|||
![]()
Yes, use a calculation form field and make sure that all the fields that
contribute to the calculation have "Calculate on exit" set in the Form Field Options. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... I am making a form with the "Text Form Field" button (from the Forms Toolbar). In some boxes I am entering text. In some I am entering numbers. Is it possible to have a box at the end of the document (ie. a "Total Amount" box) that will have automatically added the numbers from specific boxes together? Word 2002 (sp3), Win XP Thank you. Nick |
#3
![]() |
|||
|
|||
![]()
Suzanne,
Thank you for the quick response. I thought I was doing this correctly but would you help with the next step... I've opened the Text Form Field Options and selected Number in the Type field. The default I've left blank. Max Length I left untouched and blank. Number format- I did change to the $ entry. I left the Macro entries blank. I left the Bookmark entry untouched. The Fill-in and calculate on exit are checked. So after 3 of these boxes have been entered (all with the "calculate on exit" boxes checked), the last box I changed the Type to Calculation. There is a default "=" in the Expression box which I read in the Word help file that is not to be changed. When I save, protect, and test this, nothing shows up in the last "Calculation" box. Clearly, I am entering something wrong, but I haven't figured out a successful combination. Is this a time for using macros? Thanks again. "Suzanne S. Barnhill" wrote: Yes, use a calculation form field and make sure that all the fields that contribute to the calculation have "Calculate on exit" set in the Form Field Options. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... I am making a form with the "Text Form Field" button (from the Forms Toolbar). In some boxes I am entering text. In some I am entering numbers. Is it possible to have a box at the end of the document (ie. a "Total Amount" box) that will have automatically added the numbers from specific boxes together? Word 2002 (sp3), Win XP Thank you. Nick |
#4
![]() |
|||
|
|||
![]()
To clarify, in the Calculation field, are you entering the bookmarks of the
fields you want to sum? I'm not really the best source on this, as I haven't used calculated fields (indeed, I have little experience with form fields at all), but I'm sure you'll need to add some sort of formula (such as Text1 + Text2 + Text3). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... Suzanne, Thank you for the quick response. I thought I was doing this correctly but would you help with the next step... I've opened the Text Form Field Options and selected Number in the Type field. The default I've left blank. Max Length I left untouched and blank. Number format- I did change to the $ entry. I left the Macro entries blank. I left the Bookmark entry untouched. The Fill-in and calculate on exit are checked. So after 3 of these boxes have been entered (all with the "calculate on exit" boxes checked), the last box I changed the Type to Calculation. There is a default "=" in the Expression box which I read in the Word help file that is not to be changed. When I save, protect, and test this, nothing shows up in the last "Calculation" box. Clearly, I am entering something wrong, but I haven't figured out a successful combination. Is this a time for using macros? Thanks again. "Suzanne S. Barnhill" wrote: Yes, use a calculation form field and make sure that all the fields that contribute to the calculation have "Calculate on exit" set in the Form Field Options. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... I am making a form with the "Text Form Field" button (from the Forms Toolbar). In some boxes I am entering text. In some I am entering numbers. Is it possible to have a box at the end of the document (ie. a "Total Amount" box) that will have automatically added the numbers from specific boxes together? Word 2002 (sp3), Win XP Thank you. Nick |
#5
![]() |
|||
|
|||
![]()
Suzanned, you are the best!
I was not using the bookmarks before. I simply gave each box that I wanted added a unique bookmark (in this case "Dollar1, Dollar2, etc...). In the box where I wanted the total displayed; in its options box, in the Expressions box I added the following right after the "="... "dollar1+dollar2+dollar3". Worked like a charm. Thank you, Thank you, Thank you. Nick "Suzanne S. Barnhill" wrote: To clarify, in the Calculation field, are you entering the bookmarks of the fields you want to sum? I'm not really the best source on this, as I haven't used calculated fields (indeed, I have little experience with form fields at all), but I'm sure you'll need to add some sort of formula (such as Text1 + Text2 + Text3). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... Suzanne, Thank you for the quick response. I thought I was doing this correctly but would you help with the next step... I've opened the Text Form Field Options and selected Number in the Type field. The default I've left blank. Max Length I left untouched and blank. Number format- I did change to the $ entry. I left the Macro entries blank. I left the Bookmark entry untouched. The Fill-in and calculate on exit are checked. So after 3 of these boxes have been entered (all with the "calculate on exit" boxes checked), the last box I changed the Type to Calculation. There is a default "=" in the Expression box which I read in the Word help file that is not to be changed. When I save, protect, and test this, nothing shows up in the last "Calculation" box. Clearly, I am entering something wrong, but I haven't figured out a successful combination. Is this a time for using macros? Thanks again. "Suzanne S. Barnhill" wrote: Yes, use a calculation form field and make sure that all the fields that contribute to the calculation have "Calculate on exit" set in the Form Field Options. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "dogfly" wrote in message ... I am making a form with the "Text Form Field" button (from the Forms Toolbar). In some boxes I am entering text. In some I am entering numbers. Is it possible to have a box at the end of the document (ie. a "Total Amount" box) that will have automatically added the numbers from specific boxes together? Word 2002 (sp3), Win XP Thank you. Nick |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbers to appear at the cursor... | New Users | |||
Form fields in frames - can I format the text (ie bold, italic)? | Microsoft Word Help | |||
How can I spellcheck the text entered into a locked form? | Microsoft Word Help | |||
Outline | Page Layout | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |