print of report is different than preview

[RonNCmale]

I downloaded How to skip used mailing labels and print duplicates in Access
2002. It seems to be working fine until I try to print. It then prints from
the first label and not as the preview showed. This is driving me buggy. What
am I missing?

 

[Allen Browne]

The knoweldgebase article you referred to works for a single-page report.
Provided you reset things in the Report Header's events, it should also work
for printing (provided you print from the first page.)

However, it does not work if you are printing reports that spill over onto
several pages, unless you actually print all the pages. This is due to the
fact that the events do not fire for the pages you don't print, so relying
on the events across several pages just doesn't work reliably.

For printing multiple copies of a label (not skipping unused labels), here's
an alternative solution that does work reliably:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html