Open Report In Fit To Screen

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I want to open a report in fit to screen. The code I found on the
Internet didn't quite work for me. How is this done?

Matt
 
I want to open a report in fit to screen. The code I found on the
Internet didn't quite work for me. How is this done?
Click to expand...

One difficulty is that the code to "fit to window" cannot be executed in the
report's own code module. You have to call it in the same code that opens the
report.

DoCmd.OpenReport "ReportName", acViewPreview
DoCmd.RunCommand acCmdFitToWindow

I would usually include...

DoCmd.Maximize

....in the Report's Open Event.
 
Thanks so much. And thanks for the explanation. I did put it in the
wrong place.

Matt
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to have a button provide a users with more than 1 choice in access? 0
News Fitness apps can be used to track down names and addresses of users 2
Access 2010 Report Button 0
Access How to prevent subReport from breaking across pages? 1
Epson XP-3150 not printing 2
Opening a form "to fit window" Access 2000 4
fit to screen 3
Excel Fit to page print options in Excel 1

Back
Top