I want to print out mark and feedback sheets for a class of pupils.

- Each pupil can have any number of pages, but typically from 1 to 4.

- For economy and easy handling I want to print double paged and double sided, thus, four pages will fit on a sheet/leaf of A4 paper.

The trick I want to achieve is to have just one pupil's marks and comments on a leaf of paper. The next pupil's marks must go on a new leaf/sheet not onto the next page.

Any ideas?

AdNo is my group for each student.

i4004,

Here's one thing to try: If you don't already have one, create a group footer for AdNo. Add a PageBreak control to the bottom of this footer. Then, in the OnFormat event for the footer, add some VBA to show/hide the PageBreak control:


That way, the page break will become visible if it's on page 1, 3, 5, etc., but will be invisible if it's on page 2, 4, 6, etc.

Hope this helps,

Dennis

Dennis I ran across this post looking for help on forcing my Acct Number group to start on a new page is the last page is not an even number. I have been messing with this thing for 2 days and trying everone's suggestions but yours did it! I think you and I thank you the original poster of this thread. I have a several thousand page report to print on a duplex printer and it was causing problems because it wasn't moving to a new page when a new group was up. so Acct 1 might have 3 pages and the fourth being the back of the 3rd and it would start a new acct on the back of the third. Now it forces it to start on an odd number page.

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Mike