Printing static text on every second page of report

[Simon Dobby]

I have a duplexing report that currently shows order details (on one or more
pages) then prints a page of "terms and conditions" on the last page.

However, the customer now requires the terms and conditions on the reverse
side of *every* page.

Can anyone please tell me how this can be achieved?

(The report currently has an active page-header, section-header and
page-footer)

 

[TerryC]

Simon,

In the "on format" event for the report section something like: (this is off
the top of my head - untested)

if [page] mod 2 = 0 then
me.[terms control name].visible = true
else
me.[terms control name].visible = false
end if

Should display the terms and conditions control on even pages only.
Substitute the "terms control name" with the name of your control that has
the terms and conditions text.

HTH

Terry

 

[Simon Dobby]

Thanks Terry, I guessed it would involve coding the onFormat event.

The "fly in the ointment" unfortunately is this: the reports (and forms and
queries) are delivered to the user as an mde, and changes to the sections
require the report to be in design view at the time of change. I currently
have the t&c info in the report footer and the rest of the stuff in page
header/footer, detail and groupheader/footer; ideally I wanted to just hide
and show whole sections at runtime, but I can't do that with an mde.

It may be that they have to settle with what they have got (they are
internal customers so won't complain too much!) but if you or anyone else has
any ideas around this then please let me know.

Regards
Simon

Simon,

In the "on format" event for the report section something like: (this is off
the top of my head - untested)

if [page] mod 2 = 0 then
me.[terms control name].visible = true
else
me.[terms control name].visible = false
end if

Should display the terms and conditions control on even pages only.
Substitute the "terms control name" with the name of your control that has
the terms and conditions text.

HTH

Terry

I have a duplexing report that currently shows order details (on one or more
pages) then prints a page of "terms and conditions" on the last page.

However, the customer now requires the terms and conditions on the reverse
side of *every* page.

Can anyone please tell me how this can be achieved?

(The report currently has an active page-header, section-header and
page-footer)

 

[Marshall Barton]

I can't even try come up with a way to do this without a lot
more information. However, while I do think there will be
more to it than what Terry posted, it does seem to be on the
right track. Your concern that you can not modify the
Visible property at runtime are unfounded.

Perhaps you can combine that idea with the fact that the
CanShrink property will operate on an invisible text box??

The key to this problem strikes me as being buried in the
details of where in the section a new page might occur.
--
Marsh
MVP [MS Access]

Thanks Terry, I guessed it would involve coding the onFormat event.

The "fly in the ointment" unfortunately is this: the reports (and forms and
queries) are delivered to the user as an mde, and changes to the sections
require the report to be in design view at the time of change. I currently
have the t&c info in the report footer and the rest of the stuff in page
header/footer, detail and groupheader/footer; ideally I wanted to just hide
and show whole sections at runtime, but I can't do that with an mde.

It may be that they have to settle with what they have got (they are
internal customers so won't complain too much!) but if you or anyone else has
any ideas around this then please let me know.

In the "on format" event for the report section something like: (this is off
the top of my head - untested)

if [page] mod 2 = 0 then
me.[terms control name].visible = true
else
me.[terms control name].visible = false
end if

Should display the terms and conditions control on even pages only.
Substitute the "terms control name" with the name of your control that has
the terms and conditions text.

I have a duplexing report that currently shows order details (on one or more
pages) then prints a page of "terms and conditions" on the last page.

However, the customer now requires the terms and conditions on the reverse
side of *every* page.

Can anyone please tell me how this can be achieved?

(The report currently has an active page-header, section-header and
page-footer)