Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like
to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Select Calculation as the Type in the Text Form Field Options dialog, then
create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Thank you for your help! It worked? :-)
"Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
So did it work or not?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Hi NFL,
Beware of trying to reference a formfield calculation in a subsequent formfield. The results are unlikely to be what you'd expect. -- Cheers macropod [Microsoft MVP - Word] "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Indeed. That's discussed in €śWD2000: Calculation in Form Field Shows Wrong
Result€ť at http://support.microsoft.com/?kbid=211253 -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "macropod" wrote in message ... Hi NFL, Beware of trying to reference a formfield calculation in a subsequent formfield. The results are unlikely to be what you'd expect. -- Cheers macropod [Microsoft MVP - Word] "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Indeed. That's discussed in €śWD2000: Calculation in Form Field Shows Wrong
Result€ť at http://support.microsoft.com/?kbid=211253 -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "macropod" wrote in message ... Hi NFL, Beware of trying to reference a formfield calculation in a subsequent formfield. The results are unlikely to be what you'd expect. -- Cheers macropod [Microsoft MVP - Word] "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
So did it work or not?
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Hi NFL,
Beware of trying to reference a formfield calculation in a subsequent formfield. The results are unlikely to be what you'd expect. -- Cheers macropod [Microsoft MVP - Word] "NFL" wrote in message ... Thank you for your help! It worked? :-) "Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Thank you for your help! It worked? :-)
"Suzanne S. Barnhill" wrote: Select Calculation as the Type in the Text Form Field Options dialog, then create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, . |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Calculate Form Fields
Select Calculation as the Type in the Text Form Field Options dialog, then
create your formula in the Expression box following the same rules as for an = field in ordinary text (in your example, it would be "= Text1 * Text2"). Be sure to check the box for "Calculate on exit" in the Form Field Options for each form field that contributes to the calculation so that the calculated field will update automatically. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" wrote in message ... MS Word 2003 - I'm in the "Text Form Field Options" dialog box and would like to know how to calculate two form fields (texboxes) and pass the value to the third form field?. For example: textbox1 * textbox2 = textbox3 Also, is there a limit of how many form fields I can calculate? Thank you, |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to calculate sum based on drop down form fields in Word | Tables | |||
Calculate fields in a protected form | Tables | |||
calculate fields | Microsoft Word Help | |||
How do I get form fields to calculate in Word? | Microsoft Word Help | |||
formula to calculate form fill-in fields | Microsoft Word Help |