Group:  Microsoft Word ยป microsoft.public.word.docmanagement
Thread: Automating SUM function in a table in a form

Geek News

Automating SUM function in a table in a form
Terri 12/11/2008 2:22:01 PM
I have created a form using a table where I enter numbers in a column. At the
bottom of a column I have pasted a SUM(ABOVE) function which should
automatically add up the column and give me the result. I need help
automating the SUM function. Right now in order to get the cell with the
SUM(ABOVE) function to calculate, I have to right click and select "Update
Field." What can I do to make it so it updates without having to manually
update?

Terri
Re: Automating SUM function in a table in a form
"Stefan Blom" <no.spam[ at ]please.xyz> 12/11/2008 2:45:45 PM
Generally, fields do not update automatically (there are a few exceptions,
but the formula field does not belong to that category).

What you can do is enable the option to update fields on print; this ensures
that you have the correct sum when printing the document. In Word 2007, do
the following: Click the Office button, and then click Word Options. In the
Display category, check the "Update fields before printing" option, and
click OK. In older versions, the corresponding option is found on the Print
tab of the Tools | Options dialog box.

Alternatively, you can make use of a macro. See the example at
http://www.gmayor.com/installing_macro.htm.

--
Stefan Blom
Microsoft Word MVP



"Terri" <Terri[ at ]discussions.microsoft.com> wrote in message
news:0179865D-5E82-4FD3-A2BC-81BB266D0915[ at ]microsoft.com...
[Quoted Text]
>I have created a form using a table where I enter numbers in a column. At
>the
> bottom of a column I have pasted a SUM(ABOVE) function which should
> automatically add up the column and give me the result. I need help
> automating the SUM function. Right now in order to get the cell with the
> SUM(ABOVE) function to calculate, I have to right click and select "Update
> Field." What can I do to make it so it updates without having to manually
> update?
>
> Terri



Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net