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!