Open report to "fit"

  • Thread starter Thread starter Hanksor
  • Start date Start date
H

Hanksor

Is it possible to open a report to fit to window instead of 100%? Any help
will be appreciated.
 
Is it possible to open a report to fit to window instead of 100%? Any help
will be appreciated.
Click to expand...

Greetings from Central Oregon!
:-)

Sure, just use this code from a command button click event to open
the report:

DoCmd.OpenReport "ReportNameHere", acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
 
Ok, Now they want it to open at 75% instead of "Fit". Any thoughts?
They're driving me crazy!!!!
 
in message
Ok, Now they want it to open at 75% instead of "Fit". Any thoughts?
They're driving me crazy!!!!
Click to expand...

Patience Hanksor, patience.
Their craziness is your job security.
:-)

Try:

DoCmd.OpenReport "ReportNameHere", acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom75

The DoCmd.Maximize is optional.
I should have mentioned this before, but if you include the
DoCmd.Maximize statement then it is a good idea to put a
DoCmd.Restore line in the *report's* Close event.

Instead of 75% you can also use the following:
DoCmd.RunCommand acCmdZoom10
DoCmd.RunCommand acCmdZoom100
DoCmd.RunCommand acCmdZoom150
DoCmd.RunCommand acCmdZoom200
DoCmd.RunCommand acCmdZoom25
DoCmd.RunCommand acCmdZoom50
DoCmd.RunCommand acCmdZoom75
 
Thanks again!!!!!!! Is it still snowing over there?
Click to expand...

You're welcome, glad to help!

We had another light dusting of snow this morning. The roads were
very slick this morning due to the melting/re-freezing from this week.
I passed many cars in the ditch on the drive in today. Hard to believe
a week and a half ago we had 70 degree F weather!! Bachelor and
the mountains are receiving some much needed extra snow pack.

Looks like a wet cold Easter. I'm expecting the kids to say, "But Dad,
why do we have to go find the candy and eggs outside with all the snow?!"

"Too bad kids, back in my day we had to search for the Easter candy in
two feet of snow with bare feet. We could not find all the candy until the
Fourth of July. Now quit your whining and get out there!"

<vbg>
 
Back
Top