Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Page In Word and Auto Calculate
I created a form page but can't figure out how to auto add a table of
numbers. For example, I have 2 text fields of type number and number format is in dollars (this can be in any number format). I bookmarked each field as NUMB1 and NUMB2. Now in a 3rd text field I created, bookmarked as SUM, I want to have the sum of NUMB1 + NUMB2. I tried to define the text field as Caclulation, the Expression as "=NUMB1+NUMB2" and the Number format as dollars. When I test out the form page I can enter in values in NUMB1 and NUMB2 but SUM always has $0.00 and never changes. I tried checking Calculate on exit and that did not have any affect. My Question is do I need to do anything else and what? Does this require a macro and where can I go to learn how to write a macro to do this and other things? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Page In Word and Auto Calculate
Hi Mike,
Delete the existing formfield that you're using for the calculation and do this instead: .. press Ctrl-F9 to create a blank field .. type "=NUMB1+NUMB2" between the field braces, so that you end up with "{=NUMB1+NUMB2}" .. add any formatting switches you need (see Word's help file) .. protect & use your form. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mr. Mike" wrote in message ... I created a form page but can't figure out how to auto add a table of numbers. For example, I have 2 text fields of type number and number format is in dollars (this can be in any number format). I bookmarked each field as NUMB1 and NUMB2. Now in a 3rd text field I created, bookmarked as SUM, I want to have the sum of NUMB1 + NUMB2. I tried to define the text field as Caclulation, the Expression as "=NUMB1+NUMB2" and the Number format as dollars. When I test out the form page I can enter in values in NUMB1 and NUMB2 but SUM always has $0.00 and never changes. I tried checking Calculate on exit and that did not have any affect. My Question is do I need to do anything else and what? Does this require a macro and where can I go to learn how to write a macro to do this and other things? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Page In Word and Auto Calculate
This is not working
First I tried creating a new field as you said and that did not work. Once I clicked Enforcing Protection the field disappeared and never showed any results when I defined NUMB1 and NUMB2. I tried to go back even after I removed Enforce Protection. Second, I tried what you said and the went to Word Help and got the following: Add a formatting switch to a field code 1. Right-click the field, and then click Edit Field. I tried this but there was not option "Edit Field" anywhere in the popup menu, not even faded out. What am I doing wrong and what do I need to do to get this to work? "macropod" wrote: Hi Mike, Delete the existing formfield that you're using for the calculation and do this instead: .. press Ctrl-F9 to create a blank field .. type "=NUMB1+NUMB2" between the field braces, so that you end up with "{=NUMB1+NUMB2}" .. add any formatting switches you need (see Word's help file) .. protect & use your form. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mr. Mike" wrote in message ... I created a form page but can't figure out how to auto add a table of numbers. For example, I have 2 text fields of type number and number format is in dollars (this can be in any number format). I bookmarked each field as NUMB1 and NUMB2. Now in a 3rd text field I created, bookmarked as SUM, I want to have the sum of NUMB1 + NUMB2. I tried to define the text field as Caclulation, the Expression as "=NUMB1+NUMB2" and the Number format as dollars. When I test out the form page I can enter in values in NUMB1 and NUMB2 but SUM always has $0.00 and never changes. I tried checking Calculate on exit and that did not have any affect. My Question is do I need to do anything else and what? Does this require a macro and where can I go to learn how to write a macro to do this and other things? |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Page In Word and Auto Calculate
Hi Mike,
Did you have the 'calculate on exit' of both formfields checked? As for setting the switches, you can do this without using Edit|Field. Simply select the field and press Shift-F9 to expose it's code. If you want to add $ formatting to the formula field, edit the code so that you end up with "{=NUMB1+NUMB2 \# $,0.00}". This will give you dollars and cents with a thousands separator. To get the same formatting with the formfields, use a number Type and make the number format $#,##0.00. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mr. Mike" wrote in message ... This is not working First I tried creating a new field as you said and that did not work. Once I clicked Enforcing Protection the field disappeared and never showed any results when I defined NUMB1 and NUMB2. I tried to go back even after I removed Enforce Protection. Second, I tried what you said and the went to Word Help and got the following: Add a formatting switch to a field code 1. Right-click the field, and then click Edit Field. I tried this but there was not option "Edit Field" anywhere in the popup menu, not even faded out. What am I doing wrong and what do I need to do to get this to work? "macropod" wrote: Hi Mike, Delete the existing formfield that you're using for the calculation and do this instead: .. press Ctrl-F9 to create a blank field .. type "=NUMB1+NUMB2" between the field braces, so that you end up with "{=NUMB1+NUMB2}" .. add any formatting switches you need (see Word's help file) .. protect & use your form. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Mr. Mike" wrote in message ... I created a form page but can't figure out how to auto add a table of numbers. For example, I have 2 text fields of type number and number format is in dollars (this can be in any number format). I bookmarked each field as NUMB1 and NUMB2. Now in a 3rd text field I created, bookmarked as SUM, I want to have the sum of NUMB1 + NUMB2. I tried to define the text field as Caclulation, the Expression as "=NUMB1+NUMB2" and the Number format as dollars. When I test out the form page I can enter in values in NUMB1 and NUMB2 but SUM always has $0.00 and never changes. I tried checking Calculate on exit and that did not have any affect. My Question is do I need to do anything else and what? Does this require a macro and where can I go to learn how to write a macro to do this and other things? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Form Page In Word and Auto Calculate
That did the trick, Thanks
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you auto calculate in word 2007 like you can in excel? | Microsoft Word Help | |||
Auto calculate in a word table | Tables | |||
form field auto calculate | Microsoft Word Help | |||
Trying to calculate totals in a Word form | Tables | |||
Can Word calculate page number in form only if data is entered in. | Page Layout |