A97 Controls calculated by Functions on multi page reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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."
 
Back
Top