page numbers - printing duplex - and groups

[jjay]

I have a report in Access 2003 (also using 2007) I am using groups and printing duplex so I have to insert a blank page for groups that end in an odd number.

I also have to print the page number as "Page 1 of 5". I have used a couple of different methods to get the "Page of Pages" to work.

and I can also get a blank page inserted by using a page break that is set to visible on mod = 2.

BUT I cannot seem to get both of them to work properly together.

Access wants to either count the blank page or if I do get it to count right, then I have a header and footer on the blank page.

Does anyone have a method to get a blank page inserted on odd pages and use the "page of pages" method for numbering.

 

[lark_tilly]

I'm assuming you're using vb code in the reports to do what you're
doing now. If you set [Page] to 1 when the GroupHeader_Format event
occurs, and the page break to visible=yes on the GroupFooter_Format event,
when mod = 2, does that get you want you want?