question for Marshall Barton

[steve]

I copied the following code that was posted last year.

This is a difficult situation. I can only come up with one

way to get that effect and it requires that the detail

section has its KeepTogether property set to Yes. You can

also not use the Page Header section for anything else.



If you can live with those restrictions, then make the page

header section as big as needed, but with room on the page

for one detail section. Place your subreport in the page

header.



Next add a page break control (named pgBreak) to the very

top of the detail section.



Now, add code to the page header's Format event:

Me.Section(3).Visible = (Me.Page Mod 2 = 0)

and add to the detail section's Format event:

Me.pgBreak.Visible = (Me.Page Mod 2 = 0)



The detail section's KeepTogether is required to prevent

part of the detail from printing on the event numbered page

after the subreport. The page break control will prevent a

detail from starting on an even numbered page.



I tested this scenario using A2003 and can not vouch for any

earlier version as there are differences in how some

versions handle making the page header invisible on some

pages.



--

Marsh

MVP [MS Access]



This is supposed to let me print a second (back) page that is different from
the actual report. I have followed the instructions and do not get the
second page. I am trying to print a contract on the back of each page ,
with the front being a delivery ticket.



I realize this code was posted last year, but it was all I could find.



I am using Access 2003.



TIA for your help.



Steve

 

[Marshall Barton]

I copied the following code that was posted last year. [snip long quoted post]
This is supposed to let me print a second (back) page
that is different from the actual report. I have followed
the instructions and do not get the second page.

I am trying to print a contract on the back of each page
with the front being a delivery ticket.

That old post is pretty much all there is I can say about
this problem. Either your report's arrangement is different
from the situation that solution addresses or you didn't
quite do what it said needed to be done.

I might be able to provide some assistance if you can
provide all of the pertinate details.

In the future, please remove unneeded parts of a quoted
post, especially all sig lines. Also, adding all those
blank lines means more scrolling, which just makes it even
more difficult to read.