Force blank page in duplex printing

[Guest]

I have a database which holds a list of issues and their associated history.
The report starts each issue on a new page and each issue may be one or more
pages long

When I use a duplex printer, I have the problem that if an issue is an odd
number of pages long (eg, 1 page), the next issue starts printing on the back
of the page, so issue one is on page 1, issue two start on page 2 and may run
onto page 3, etc

What I want to achieve is having issue one print on page 1, then if
necessary through a blank page so issue two starts on page three, etc.
Therefore, each new issue will start printing on an odd page

The reason I need to do this is that each issue might be updated
independently and I don't want to reprint the entire report each time, just
the changed issue - that way I can just replace the affected pages

I don't have any VB skills, so either need a way of doing it using Access or
need VB code that I can cut and paste in somewhere

 

[Guest]

Hi Teddi

I have the exact same problem - I've googled until my eyeballs hurt with no
luck. Have you found a solution?

Kelly

 

[Guest]

Sadly, no, not yet. I've been thinking about using a temporary table and
stepping through generating the report separately for each item. That could
be put in a loop and then it becomes automatic - problem is that my VB skills
are about 10yrs out of date so it may take me some time

If I get a solution, I will post it on this message board

Teddi