Report Issue

[Kevin Field]

Here is an interesting one for all of you amazing experts out there.

I have a report which has a front sheet and back sheet. The above are both in the detail section of the report with a page break between them. When you print this report, depending on the amount of clients it picks up, you will get double sided printing with the front being the actual client details and the rear being an image. This carries on ad infinitum

However, i ran this yesterday and because a client had a lot of policies (sub reports on the client detail page which can grow or shrink) the order got screwed up because it rolled over onto a new page. If you now print this double sided the order is destroyed and it looks stupid.

I need some advice. How can i make the report know that the first page has overrun and skip a page in order to bring back the correct front/back order.

confused.com

Thanks!

 

[vbaInet]

What you could do is:

1. Check the Page number (Me.Page) of the last record of each Client group. If it's an odd number (i.e. using Mod), do nothing else if it's even then continue with step 2 below.
2. If it's even (which means it's gone over to the next page, then you need to FILL a page with more records until the page number becomes Odd again. You fill the page by using the current record for that client, pause NextRecord, then MoveLayout. That will cause the current record to print to the next line without going to the next record.
3. To perform step 2 you need the following two methods:

Me.MoveLayout
Me.NextRecord

This methods are set using True or False, i.e. Me.MoveLayout = True

I couldn't find any approriate links re it's use but the help files explain their use. This link might help also:

http://bytes.com/topic/access/answers/201557-blank-lines-reports

Happy coding!

 

[stopher]

2. If it's even (which means it's gone over to the next page, then you need to FILL a page with more records until the page number becomes Odd again.

Just insert another page break. Make the page break visible or not depending on whether the page is odd/even.

Chris

 

[vbaInet]

Ah, that could work Chris.