Calculate Form Fields
in [Document Management]
|
From: NFL on 13 May 2010 12:34 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,
From: Suzanne S. Barnhill on 13 May 2010 12:49 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" <NFL(a)discussions.microsoft.com> wrote in message news:2152891F-00A1-4082-92CF-A46E7BB38E13(a)microsoft.com... > 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, >
From: NFL on 13 May 2010 16:54 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" <NFL(a)discussions.microsoft.com> wrote in message > news:2152891F-00A1-4082-92CF-A46E7BB38E13(a)microsoft.com... > > 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, > > > > . >
From: Suzanne S. Barnhill on 13 May 2010 18:04 So did it work or not? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "NFL" <NFL(a)discussions.microsoft.com> wrote in message news:2570393F-3922-47CE-8204-268E6C0EFA1D(a)microsoft.com... > 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" <NFL(a)discussions.microsoft.com> wrote in message >> news:2152891F-00A1-4082-92CF-A46E7BB38E13(a)microsoft.com... >> > 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, >> > >> >> . >> >
From: macropod on 15 May 2010 07:29
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" <NFL(a)discussions.microsoft.com> wrote in message news:2570393F-3922-47CE-8204-268E6C0EFA1D(a)microsoft.com... > 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" <NFL(a)discussions.microsoft.com> wrote in message >> news:2152891F-00A1-4082-92CF-A46E7BB38E13(a)microsoft.com... >> > 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, >> > >> >> . >> |