HI everyone

[Accessme2]

I need to print a report, This report is print on three different color paper(Yellow, pink and white) so I need to print the first page 3 time the the second page 3 time and so on what ever the pages are. I was able to do it if I preview the report select the printer and tell it hoe many copies I need. but if I try to code this process as followed:

DoCmd.OpenReport "MY_REPORT", acViewPreview
DoCmd.PrintOut , , , , 3

This process give me 3 copies of the report but it print page one then second then third so it got o be the collate but don't know how to turn it off or on.

Any help would be appreciated.

accessme2

 

[Kryst51]

Here's a thread that has some ideas about collating.