Maximizing a report in 2007

[wmdmurphy]

In my app I need reports to open maximized to avoid the user having to do
this manually. When I add docmd.maximize to either the Open or Activate
event the reports do open maximized, but there is no navigation bar at the
bottom of the report preview screen. Is there a setting to avoid this?

Bill

 

[Jeanette Cunningham]

Hi Bill,
try this instead of using docmd.maximize.

In the code that opens the report put
DoCmd.OpenReport "rptName", acViewPreview
DoCmd.RunCommand acCmdZoom100

I use this and it opens the report at full size and you can see the
navigation bar.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Hi Bill,
try this instead of using docmd.maximize.

In the code that opens the report put
DoCmd.OpenReport "rptName", acViewPreview
DoCmd.RunCommand acCmdZoom100

I use this and it opens the report at full size and you can see the
navigation bar.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[wmdmurphy]

Jeanette,

That worked for me, but the report was opening in a small window in mid
screen, and I had to click on the maximize button to make it maximize. I
found the following code example at
http://www.accessruncommand.com/codeex/238to245.htm, and this caused the
report to open full screen, zoomed to 100% and with a navigation bar:

DoCmd.OpenReport "rptName", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
DoCmd.RunCommand acCmdZoom100

Bill

 

[wmdmurphy]

Jeanette,

That worked for me, but the report was opening in a small window in mid
screen, and I had to click on the maximize button to make it maximize. I
found the following code example at
http://www.accessruncommand.com/codeex/238to245.htm, and this caused the
report to open full screen, zoomed to 100% and with a navigation bar:

DoCmd.OpenReport "rptName", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
DoCmd.RunCommand acCmdZoom100

Bill

 

[Jeanette Cunningham]

Funny, I tried that code a while ago and I had to remove the 2 lines for
maximize and fit to window to get the desired result.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

Funny, I tried that code a while ago and I had to remove the 2 lines for
maximize and fit to window to get the desired result.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia