A97 Controls calculated by Functions on multi page reports

S

Shawn C

I have a report that calculates values, by functions, for groups of various
sizes in a report. The weird thing is that the controls only show the correct
values when I first preview every page in the report. If I skip from the
first page to the last page, I only get totals for records on those two
pages. It is as if those controls only calculate when those pages are
previewed. Printing is another story!!

Any thoughts???
 
A

Allen Browne

If the functions are called in the report's events (e.g. the Format event of
the Detail section), you are correct: Access may fire them only if you
print/preview the particular page.

That means any attempt to accumulate a total that spans more than one page
using the report events is flawed. You must use an alternative approach,
such as a Running Sum text box.

In the same way, using the report events to add spacing between records or
to repeat records (e.g. print multiples of a label) will also yield
unreliable results, and can also lead to Access giving you nonsense such as
"Page 7 of 4."
 
Top