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!

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

Zoom and the On Open Event 1

Status
Not open for further replies.
Mabjro

Mabjro

Programmer
Jun 3, 2003
127
US
Is there a way to make a report automatically zoom to fit when it opens. I tried using VB and using runcommand zoomtofitwindow, but I get an error that that command is not available now. Any Ideas anyone?

Thanks
 
Sort by date Sort by votes
Are you opening the report via a command button on a form?? If so, after your OpenReport statement, insert this code:
Code: 
DoCmd.RunCommand acCmdFitToWindow
 
Upvote 0 Downvote
Works like a dream. Thank you very much and for that you get a star.

Mabjro
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
886
caykamanj1966
caykamanj1966
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
573
dhookom
dhookom
Zandy12
  • Locked
  • Question
Repeat the Report Header after Page Header / Details ends.
Replies
1
Views
868
dhookom
dhookom
JohnXr
  • Locked
  • Question
thread703-757058 I use the followi
Replies
4
Views
450
Axworthy
Axworthy
caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
365
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top