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!

Zoom Report

Access Howto:

Zoom Report

by  Bullschmidt  Posted    (Edited  )
How about having a report open and immediately toggle to zoom view. And then the client can easily click one time to be anywhere on the report page that he wants to see close up. To do this, put code such as the following behind the command button that opens the report:

DoCmd OpenReport "MyReport", A_Preview

SendKeys "z", True

Note that the SendKeys statement sends out a small z just as if it had been typed from the keyboard to toggle to zoom view. Unfortunately this code does NOT work from the report's OnOpen property.

J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access - Sample Access Invoices Database
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top