On_Print event?

  • Thread starter Thread starter Dennis Snelgrove
  • Start date Start date
D

Dennis Snelgrove

In Access 2002, I've got a report that will vary in length from 1 page
to probably 50 or more. The report gets called from a screen with a
bunch of search options, and gives the user a preview on the screen.
What I'm looking for is a way to make the report check its own length,
and if it's over a certain number of pages, confirm with the user
before redirecting itself to a network printer. By default, users have
a local desktop inkjet printer, but if the report is over maybe 5 pages
then it's much faster to go to a network laserjet.

I figured that I'd do all this with the Printer object in the Print
event of the report, but I don't think there is one. Any suggestions?
 
The "Pages" built-in variable will tell you how long the Report is. Perhaps
someone else can discuss re-routing the Report to a particular printer. I've
always thought the user should make that selection... I can't recall ever
doing anything other than opening Reports in Preview and letting the user
decide whether and where to print them.

Larry Linson
Microsoft Access MVP
 
Back
Top