Opening Report Sizing Mgmt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this question has been asked a bunch of times and I did scroll several
pages back of past Q&As to see an answer - but did not find.

One report.

It is opened by several different OpenReport function buttons found on
various Form pages in the application.

Some open the report off to the left and rather small, some open it in the
middle in full screen.

The button wizard didn't ask about the report size, and the report property
would be the same for all openings - yet the same report opens differently
depending on which button is used. How does one control the opening size of
a Report?

I just don't seem to have intuitive controlable feature or maybe control
"findability" on this point .... enlightment welecomed. thnks
 
I know this question has been asked a bunch of times and I did scroll several
pages back of past Q&As to see an answer - but did not find.

One report.

It is opened by several different OpenReport function buttons found on
various Form pages in the application.

Some open the report off to the left and rather small, some open it in the
middle in full screen.

The button wizard didn't ask about the report size, and the report property
would be the same for all openings - yet the same report opens differently
depending on which button is used. How does one control the opening size of
a Report?

I just don't seem to have intuitive controlable feature or maybe control
"findability" on this point .... enlightment welecomed. thnks
Click to expand...

And how do you want it to open? Fit To Window? 100%? 75%? Maximized?

In the form event that opens the report, code:

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

In the report's Open event:

DoCmd.MoveSize 2*1440,1*1440

to position the report 2 inches from the left and 1 inch down from the
top. All measurements are in Twips, 1440 per inch.

Look up the RunCommand in VBA help to see what other Zoom sizes are
available, as well as the acCmdFitToWindow.
Also look up the MoveSize method to position as well as size the
report window.
 
wow - great reply - thanks...

so one really must go into coding to get the same single report to open
consistently?

am generally a microsoft fan not a basher - but I would have to say this is
a major conceptual flaw in terms of basic end user controlability....one
would think the default would be for it to open identically each time and one
would have to go into code to make it open differently !!
 
Back
Top