My froms need to include calculations

A

Ali

HI!
I have developed some forms that need to have automatic calculations in
parts of the forms. I know how to do it in Excell but the options in Word
look limited. How can I include a table with formulas in my form similar to
Excel? Any assistance is appreciated.
 
S

Stefan Blom

You can make use of text form fields of the "Calculation" type to perform
calculations in a protected form.

To set the type of a text form field: Unprotect the form, and then
double-click the form field to display the Text form Field Options dialog
box. Under "Type," choose "Calculation."

Don't forget to also check the "Calculate on exit" option for the fields.
 
A

Ali

Thanks fo r the info. In Excel all cells have their address that helps
compiling the formula. This is not the case in MS WORD. HJow can I access the
formulas when I am in Word?
--
Thanks
Ali


Stefan Blom said:
You can make use of text form fields of the "Calculation" type to perform
calculations in a protected form.

To set the type of a text form field: Unprotect the form, and then
double-click the form field to display the Text form Field Options dialog
box. Under "Type," choose "Calculation."

Don't forget to also check the "Calculate on exit" option for the fields.
 
S

Stefan Blom

You can use cell addresses in Word tables too. If you find it difficult to
keep track of the cell addresses, take a look at
http://gregmaxey.mvps.org/Table_Cell_Data.htm.

--
Stefan Blom
Microsoft Word MVP


Ali said:
Thanks fo r the info. In Excel all cells have their address that helps
compiling the formula. This is not the case in MS WORD. HJow can I access
the
formulas when I am in Word?
 
G

Graham Mayor

If you are using form fields, then each such field has a bookmark name. You
can also calculate the 'boomarks' using a formula field

eg
{=({Text1} + {Text2})}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top