Access Report Printing

Question

Hi everyone,

I have an Access report that is pulled from a query. I've been trying to print multiple copies of the same report but rather it printing like so: Page 1, Page 2, Page 1, Page 2.... It prints as: Page 1, Page 1, Page 2, Page 2.

What print settings do I need to change to have it print in order?

Answer 1

In the bottom right corner, there is a collate checkbox as I stated. Make sure its checked.

Answer 2

I created a Print button from the button wizard so the Macro written is RunMenuCommand>PrintObject

So when I press the button, the print dialog box comes up (the picture below). I then change the copies to 2 and then it prints out in the order stated in my original post.

Answer 3

There is a property in the Print dialog to collate a report. If you check off that property it prints all pages in one copy then the next copy etc. If unchecked it prints each page separately.

As George says, showing what you are doing to print the report will help us help you.

Answer 4

Context is so important. Here, for example, all we know is that you are "printing multiple copies of a report", but we don't yet know HOW that is being done, although some might be able to make a good guess. Please show us the code used to do this print job, or explain, step by step, the process at least. That will help spot some aspect that can be changed....