Print Preview Discrepancies

  • Thread starter Thread starter mckitlk
  • Start date Start date
M

mckitlk

Hello everyone,

I created an Access 2002 report and gave users the option of either
printing it directly or viewing it in Print Preview. That's because
the report is too long to print very often. It contains calculated
fields,group totals, and overall totals, the sort that can be gotten
only programmatically, not using Access' built-in features or with SQL.
I do the calculations in the various Print events for the detail and
various group footers.

It works fine when it's first viewed, but as you scroll back and forth
through the report, the totals start increasing erratically. This
isn't even consistent-- sometimes they change and sometimes they don't.

I've been researching this and know it has something to do with the way
the code is called multiple times, but that just won't do. Does anyone
have any ideas for changes I can make to ensure that the calculations
will remain correct?

Thanks in advance!

Laura
 
I created an Access 2002 report and gave users the option of either
printing it directly or viewing it in Print Preview. That's because
the report is too long to print very often. It contains calculated
fields,group totals, and overall totals, the sort that can be gotten
only programmatically, not using Access' built-in features or with SQL.
I do the calculations in the various Print events for the detail and
various group footers.

It works fine when it's first viewed, but as you scroll back and forth
through the report, the totals start increasing erratically. This
isn't even consistent-- sometimes they change and sometimes they don't.

I've been researching this and know it has something to do with the way
the code is called multiple times, but that just won't do. Does anyone
have any ideas for changes I can make to ensure that the calculations
will remain correct?
Click to expand...


What?
You don't believe the other posts on this issue? ;-)

Sorry, but you'll have to find another way. It is just
impossible to use event procedures to reliably calculate
values from anything other than the current record.
 
Back
Top