Print Preview Different than Actual Print

[Daniel T. E. Francis]

In Access 2000 or 2002. I have a report with a report
footer. I am counting the number of items in the group
headers. In print preview mode the total is correct.
When the report is physically printed the count is
doubled. i.e. oprint preview says 1 record, when
physically printed it says 2 records. I have traced
through the code with VBA and do not see any where that
the calculation is being performed twice. It is based on
a query and the query ios only passing 1 record (for this
exapmle). Any help would be appreciated.

Dan

 

[fredg]

In Access 2000 or 2002. I have a report with a report
footer. I am counting the number of items in the group
headers. In print preview mode the total is correct.
When the report is physically printed the count is
doubled. i.e. oprint preview says 1 record, when
physically printed it says 2 records. I have traced
through the code with VBA and do not see any where that
the calculation is being performed twice. It is based on
a query and the query ios only passing 1 record (for this
exapmle). Any help would be appreciated.

Dan

Dan,
The numbers are summed when previewed, then again when printed, without
having been reset.
Reset the controls to 0 in the Report Header Format event.

Something like:
[ControlinGroupHeader1] = 0
[ControlinGroupHeader2] = 0
etc.

This way they are initialized to 0 both before previewing and before
printing.