Re: print of report is different than preview

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"RonNCmale" <RonNCmale@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:28FC2AC6-E454-4113-ACB4-29BAF6BCCC3B@xxxxxxxxxxxxxxxx
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?

.

Relevant Pages

  • Re: Determine copy number within Report
    ... Add a page break after each page and repeat the invoice as many times as ... In other words, if it is a 3 page invoice, make a 3 page report. ... Use something similar to printing multiple copies of the same label to ...
    (microsoft.public.access.reports)
  • Re: creating a label report in access
    ... These are two seperate label reports. ... one report is for file folder labels and I do not print the whole page at one ... it to start printing on the third label. ... Private Sub Detail_Print ...
    (microsoft.public.access.reports)
  • Re: How to show / print a system variable in a report
    ... It relies on repeating some report events, but if you print just some pages ... Printing a Quantity of a Label ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.reports)
  • Re: Report Header in Mailing Labels...
    ... The query uses 12 different fields to create the mailing labels. ... In the Report Header of the mailing labels, I am only printing 3 separate ... A label that names the 'report', a label that just says ... What I would like to do is to put the 3 separate items on the first label, ...
    (microsoft.public.access.reports)
  • Re: Change Labels in Reports
    ... Then I use a text box instead of a label in the ... report. ... rather than allenbrowne at mvps dot org. ... The first label would display ...
    (microsoft.public.access.reports)