View Single Post
  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Bettina Bettina is offline
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Susan,

I'm really confused. I have created a document with text field boxes so that
people can enter numbers, check boxes, etc. One column of my table should
also have text field boxes for people to enter numbers. However, I want the
subtotal cell below it and the total below the subtotal to add the numbers
automatically based on what a person enters.

When I click on a given cell in the column, I add a text field and I have
chosen properties where I have changed the type to "calculation". The
expression box automatically adds a =. The max length is unlimited.'

I noticed that the text field box automatically locks now. I have 13 cells
in a column in a table where I want user's to enter numbers that will
automatically add up in the subtotal and total cell in the same column.

One of the reasons why I'm inquiring here is because I tried to make sense
of the help menu in word all day yesterday.

Please help. Thank you.
--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already using form
fields in a protected form. If you are, then a calculation field is one type
of Text Form Field. If you're just using an unprotected table, then you can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
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.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell of

the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and

choose
insert, field, there's no category for calculation. There is a box to

choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in

the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
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.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter

information
into
text boxes.

One part of the form has a table and I want people to enter numbers

into
one
column. I would like the subtotal and total column to automatically

add up
whatever numbers are entered.

Is this possible?
--
Bettina