Aug 28 2007, 08:30 AM
Is there any way for me to print double sided with some constraints?
I have a database that is printing 5-6 (3 double sided) page letters. If the letter is 6 pages I am fine, it just finishes one letter on the back side of a page and begins a new page for the next letter. My problem is for a 5 page letter it wants to print the last page of the letter on the front of a page then begin printing the next letter on the back of the same page. Is there any way around this to get a new letter to start on the front of a new page of paper?
Aug 28 2007, 09:40 AM
Add a page break control to your report at the 'end' of the letter design - i assume that this must be in a group footer section , but that is not really important, except that you know where it is.
When in the Format event procedure for that section check the page number and make the control visible or invisible:
If Me.Page Mod 2 = 0 then ' currently an even page
Me.pgBreak.Visible = true
Me.pgBreak.Visible = false
Aug 29 2007, 02:52 PM
I'm trying this but its not working. Its not recognizing the method of pgBreak. Is this a new method in a new version. I am running on Access 2000. I looked through other available methods and I'm not finding anything that will do this.
Aug 29 2007, 05:17 PM
Hi, I am trying to print double sided. Can you please help me in that?
Aug 29 2007, 05:35 PM
'pgBreak' must be the name of YOUR pagebreak control.
Aug 29 2007, 05:59 PM
I am sorry, I am new to VBA. I didn't understand you
Aug 30 2007, 12:56 AM
Jumping in ...
From the Control Tool box, add a page break control to the report. Then you will be able to use the suggested code.
Aug 30 2007, 08:16 AM
Whoa, brain malfunction...
Thanks guys it works perfectly. Now I just need to figure out how to turn the group header off for that blank page that I had set to repeat section.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here