Reply
 
Thread Tools Display Modes
  #1   Report Post  
dogfly
 
Posts: n/a
Default Forms- adding numbers from multiple "Text Form Fields"

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   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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   Report Post  
dogfly
 
Posts: n/a
Default

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   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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   Report Post  
dogfly
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers to appear at the cursor... ~D~ New Users 11 February 1st 05 04:49 AM
Form fields in frames - can I format the text (ie bold, italic)? La La Lara Microsoft Word Help 3 January 28th 05 03:09 PM
How can I spellcheck the text entered into a locked form? Missy Microsoft Word Help 1 January 20th 05 05:20 PM
Outline Renee Hendershott Page Layout 2 December 25th 04 02:49 PM
Text Form Field Ref in Footer Won't Update on Screen StarWine Microsoft Word Help 3 December 6th 04 06:17 PM


All times are GMT +1. The time now is 12:07 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"