DoCmd.Maximize on report

[Scott]

I put captioned command in open event to have a full screen. It works on
landscape correctly but not portrait. In portrait, it opens to full page
Fit screen. Can someone advise how to open it to 100%.

Thanks,

Scott

 

[Arvin Meyer [MVP]]

Something like this in your open report button:


Private Sub cmdOpen_Click()
DoCmd.OpenReport "YourReportName", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom100
End Sub

 

[Scott]

Thanks Arvin! However, I got error message that the command or action 'Zoom
100%' isn't available now on my Access 2003. Any idea?

Scott

 

[Arvin Meyer [MVP]]

I just tested it and it worked for me. It should work for you. If it
doesn't, you might try putting the following in the report's OnOpen event:

DoCmd.Maximize
DoCmd.RunCommand acCmdZoom100
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com