Preview Fits

  • Thread starter Thread starter Scott C
  • Start date Start date
Scott,

Yes. The below should work for you. You'll just need to replace
"YourReport" with your actual report name and put this code in the event
procedure that you use to open your report, like a button click event.

DoCmd.OpenReport "YourReport", acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
 
Thanks!

That's just what I needed.

Scott
-----Original Message-----
Scott,

Yes. The below should work for you. You'll just need to replace
"YourReport" with your actual report name and put this code in the event
procedure that you use to open your report, like a button click event.

DoCmd.OpenReport "YourReport", acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow





.
Click to expand...
 
Scott said:
Is there a way to set the ,acPreview , to open in "Fit"
mode?
Click to expand...


You have to add a line of code immediately after the
OpenReport line:

DoCmd.RunCommand acCmdFitToWindow
 
Back
Top