I have a report grouped by SalesAgents and their Customers. I am printing on a duplex printer. Each SalesAgent gets their own report showing their own customers. The number of customers for each Sales Agent can be anywhere from 1 to 1000.
When I print to my duplex printer, any SalesAgent section that is only 1 page (or any odd number of pages) long has the next SalesAgent(SA) info printed on the back that page (this is bad).
For example, if the report shows the output as:
SA1, 1 page long
SA2, 1 page long
SA3, 2 pages long
it prints out as:
SA1, side 1 of sheet 1
SA2, side 2 of sheet 1
SA3, side 1 and 2 of sheet 2
but what I want is:
SA1, side 1 of sheet 1
nothing on side 2 of sheet 1
SA2, side 1 of sheet 2
nothing on side 2 of sheet 2
SA3, side 1 and 2 of sheet 3.
Does this make sense?
I know the logic of what needs to be done, I just do not know how to do it.
The logic is:
If SalesAgent group footer page number is odd, then print a blank page after it (incrementing the page number if it doesn't do so automatically so that further page numbers are accurate).
I know it probably involves the use of Mod in the group footer:
=IIf ([Page]mod2=1, print a blank page)
I would also like this to be accurate in Print Preview so that I can tell it is correct, so the “print a page” code should show the appropriate blank page in print preview (not just a code sent only to the printer).
What I need to know is:
What is the code for printing a blank page?
Where exactly do I put the needed code (including page mod 2 above)?
Does this go in an unbound control?
Please be explicit when replying, do not assume I know anything.
When I print to my duplex printer, any SalesAgent section that is only 1 page (or any odd number of pages) long has the next SalesAgent(SA) info printed on the back that page (this is bad).
For example, if the report shows the output as:
SA1, 1 page long
SA2, 1 page long
SA3, 2 pages long
it prints out as:
SA1, side 1 of sheet 1
SA2, side 2 of sheet 1
SA3, side 1 and 2 of sheet 2
but what I want is:
SA1, side 1 of sheet 1
nothing on side 2 of sheet 1
SA2, side 1 of sheet 2
nothing on side 2 of sheet 2
SA3, side 1 and 2 of sheet 3.
Does this make sense?
I know the logic of what needs to be done, I just do not know how to do it.
The logic is:
If SalesAgent group footer page number is odd, then print a blank page after it (incrementing the page number if it doesn't do so automatically so that further page numbers are accurate).
I know it probably involves the use of Mod in the group footer:
=IIf ([Page]mod2=1, print a blank page)
I would also like this to be accurate in Print Preview so that I can tell it is correct, so the “print a page” code should show the appropriate blank page in print preview (not just a code sent only to the printer).
What I need to know is:
What is the code for printing a blank page?
Where exactly do I put the needed code (including page mod 2 above)?
Does this go in an unbound control?
Please be explicit when replying, do not assume I know anything.
