Starting next customer on odd page number.

[Guest]

I am printing douple-sided a report about customers' actions.
Each customer has different count of pages (1 or 2 or 3 or . . .)
How can I get an even number of pages to every customer?

Now it happens that on the same paper there can be information about two
customers, which is not suitable - next customer´s info can now start on the
other side of the paper!

 

[Allen Browne]

In report design view, add your CustomerID field to the Sorting And Grouping
Dialog (View menu.) If you already have a CustomerID group footer, then add
the field to the dialog a 2nd time.

Add a Page Break control from the Toolbox to this Customer ID group footer.
Set the On Format property to event of this section to:
Event Procedure
Click the Build button (...) beside this.
Access opens the code window.
Between the "Private Sub..." and "End Sub" lines, enter:
Me[PageBreak1].Visible = (Me.Page Mod 2 = 1)

That gives a page break when the page number is odd. The next page is then
even, and prints only what is in this new CustomerID group footer (which is
nothing.)

Presumably you have already set the Force New Page property of your
CustomerID header to Before Section. Therefore it always starts on a new
page, which makes it odd.