Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use vba to remove a page from an Access Report 1

Status
Not open for further replies.

vbLew

Programmer
Feb 28, 2005
22
US
Hello All,
Does anyone know how to remove a page within an Access Report. For instance, is there code to remove all even pages or all odd pages of an Access Report.
Thanks
 
How are ya vbLew . . .

From my notes . . . Add example code below to the [blue]Print[/blue] event [purple]of each section of the report[/purple]:
[ol][li]To remove a specific page:
Code:
[blue]   If Me.Page = 4 Then Cancel = True[/blue]
[/li]
[li]Remove all even pages:
Code:
[blue]    If Me.Page Mod 2 = 0 Then Cancel = True[/blue]
[/li][/ol]
Note: [purple]Pages are not actually removed, but rather are ejected as blank sheets from the printer . . .[/purple]

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top