By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,059 Members | 1,866 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,059 IT Pros & Developers. It's quick & easy.

Print even number of pages

Expert 100+
P: 218
Hi
I need to print a report which will always output an even number of pages (this is for duplex printing).
ie, if the report ends with an odd number of pages, I need to output a blank sheet...

I've tried playing with 'Page' and 'Pages', but no luck!
Anyone know of a quick/dirty way of doing this?

All help gratefully received
TIA
Steve
Mar 6 '07 #1
Share this Question
Share on Google+
8 Replies


Rabbit
Expert Mod 10K+
P: 12,357
Why would you need that?
Mar 6 '07 #2

Expert 100+
P: 218
Client requirement!!!!!!!!! <G>

Steve
Mar 6 '07 #3

Rabbit
Expert Mod 10K+
P: 12,357
What I meant was that there's no point in printing a blank page at the end of the report. Whether or not you do this the results are the same, you get one sheet with printing only on one side.
Mar 6 '07 #4

Rabbit
Expert Mod 10K+
P: 12,357
Unless you need to print multiple copies, in which case I don't know how that works in duplex printing. If this is the case, try printing two copies and see if you have to go through the trouble of printing a blank page. Because I suspect it may be the case that you won't have to print a blank page.
Mar 6 '07 #5

Expert 100+
P: 218
Hi, Rabbit

Sorry if I haven't made myself clear as to the reason for my post...
I need an even number of sheets because this report will be printed DUPLEX (ie, both sides)
Clearly, if there is an odd number of sheets (and this includes the number of sheets for each group break), the duplex printing of the back side will not be in sync with the numbering of the front.

HTH
Steve
Mar 6 '07 #6

Rabbit
Expert Mod 10K+
P: 12,357
Hi, Rabbit

Sorry if I haven't made myself clear as to the reason for my post...
I need an even number of sheets because this report will be printed DUPLEX (ie, both sides)
Clearly, if there is an odd number of sheets (and this includes the number of sheets for each group break), the duplex printing of the back side will not be in sync with the numbering of the front.

HTH
Steve
I understand what duplex printing is. What I don't understand is why this is a problem if you're only printing one copy. Like I mentioned previously, it might be a problem if you print more than one copy. But I can not be sure of this. Have you tried to print more than one copy so that you know this to be a problem?

I don't understand what you mean by "the duplex printing on the back side will not be in sync with the numbering on the front."
Mar 6 '07 #7

ADezii
Expert 5K+
P: 8,623
Hi
I need to print a report which will always output an even number of pages (this is for duplex printing).
ie, if the report ends with an odd number of pages, I need to output a blank sheet...

I've tried playing with 'Page' and 'Pages', but no luck!
Anyone know of a quick/dirty way of doing this?

All help gratefully received
TIA
Steve
To Print only the Even Pages of a Report, place this single line of code in the Print() Event of any Section that is printable. For instance in this test Report, the Report's Header, Detail, and Footer Sections will be printed.
Expand|Select|Wrap|Line Numbers
  1. Private Sub ReportHeader_Print(Cancel As Integer, PrintCount As Integer)
  2.   If Me.Page Mod 2 = 1 Then Cancel = True
  3. End Sub
Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
  2.   If Me.Page Mod 2 = 1 Then Cancel = True
  3. End Sub
Expand|Select|Wrap|Line Numbers
  1. Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
  2.   If Me.Page Mod 2 = 1 Then Cancel = True
  3. End Sub
Mar 6 '07 #8

Rabbit
Expert Mod 10K+
P: 12,357
That's not what they want. They want to print an extra blank page at the end if the report turns out to be an odd amount of pages.
Mar 6 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.