Duplex Access Report problem with group ending on odd pages

[patelam8]

We have a DUPLEX report to print that is grouped on a dealer code. This means for every new dealer we need to start with a new page number and new page. This works fine till the dealer codes end on the even pages. However, for the dealer codes ending on odd pages, the new dealer code starts on the other side (even side) of the page. We somehow need to insert a blank page between each group of dealer code and I have tried everything that could possibley work.

Please help!!!!!!!

 

[patelam8]

Solution:

Add page break to the footer.

Add the following event procedure to the On Format property

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
If Page Mod 2 = 1 Then blankPage.Visible = True Else blankPage.Visible = False
Page = 0
End Sub

Thanks

 

[tsonnenl]

Does anyone know how to do this in conjunction with reassigning page numbers as described in KB 306127? Using this method for generating a blank page, my page numbers get all fouled up...

TIA.

Todd

 

[MichaelRed]

... I have tried everything that could possibley work ... ,

apparently not (yet?)

The only thing I see wrong with the soloution already offered is that patelam8 reset the page number to zero and did not include the criteria re the following record.

Personally, I would do it slightly differently, with the page break in the page header, saving the current 'dealer code' on the detail of each record, and camparing the (next) dealer code at each record. Whwn ever the dealer code changes, invoke the page break. Since we collecively know little about the details of the report, it's source rrecords and properties (e.g. the sorting and grouping criteria) giving much more than generalized thoughts is somwhat pointless, and even these will usually need at least SOME creativity and/or emblishment on your part.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places