How do I get each section to start printing on an odd page?

[shay]

Hi all


Report's written and working fine apart from one thing. It starts printing each section on a new page but, because in our efforts to save trees we have double-sided printers, I sometimes get two one-page section reports back-to-back but each one has to go to a different person!

I need to be able to get each section to start on an odd-numbered page. Does anyone have any ideas for a simple solution. I could write code to print the report for one section at a time but just thought I'd ask the question in case anyone out there has already solved this one.

Regards

shay

 

[Rich]

Article ID: Q101075

 

[shay]

Thanks for that Rich but the article wasn't quite what I was looking for as it describes how to print separately the odd and even pages of a report.

My report has around 10 groups and what I want to do is start printing each one on an odd page.

From the KB article, I know how to identify when a new group is about to be printed on an even page but is there any way of sending a page throw in VBA.

Any thoughts appreciated.

shay