Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2004

Tip: Looking for answers? Try searching our database.

Updating Calculations before Printing/Saving

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janna - 25 Jun 2004 20:30 GMT
I have a form with numeric fields set to calculate on
exit, which adjusts a final total in a field at the bottom
of the form.  
This works well, except for the following:
If the user enters a number in one of the numeric fields
and then doesn't exit the field by tabbing out or clicking
into another field, when they print or save the document,
the final total doesn't get updated at the bottom of the
form. Is there some macro I can run to update calculations
before printing or saving?  Thanks!
macropod - 26 Jun 2004 12:32 GMT
Hi Janna,

Make sure that the 'update fields' box is checked under Tools|options|Print.
That may solve the print problem. Saving & closing the document, then
re-opening it will also cause fields to update, though re-using bookmarks
for multiple calculations can cause the wrong values to be used in the
update when the document is re-opened. Other than that, Pressing Ctrl-A then
F9 will update all fields in the body of the document.

Cheers

> I have a form with numeric fields set to calculate on
> exit, which adjusts a final total in a field at the bottom
[quoted text clipped - 6 lines]
> form. Is there some macro I can run to update calculations
> before printing or saving?  Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.