page numbering - printing duplex - and groups

[jsanbor1]

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.

 

[lameid]

You might try searching the forums for an answer as it seems familiar to me but I don't remember the answer...

Although, if you have everything else working, why not just conditionally set the visible property of sections appearing on your page depending on the test to determine if it is the result of a page break.