G Guest Dec 19, 2005 #1 When I code an event to Preview Report, I want the report to display full screen, not a partial screen. How do I do this?
When I code an event to Preview Report, I want the report to display full screen, not a partial screen. How do I do this?
F fredg Dec 19, 2005 #2 When I code an event to Preview Report, I want the report to display full screen, not a partial screen. How do I do this? Click to expand... Don't know what you mean by 'full screen' or 'partial screen'. Any way, one of these runcommand's or Maximize is probably what you are looking for. In the event used to open the report: DoCmd.OpenReport "ReportName", acViewPreview DoCmd.Maximize DoCmd.RunCommand acCmdZoom100 or... DoCmd.RunCommand acCmdFitToWindow Look up the other various Zoom sizes available in VBA Help.
When I code an event to Preview Report, I want the report to display full screen, not a partial screen. How do I do this? Click to expand... Don't know what you mean by 'full screen' or 'partial screen'. Any way, one of these runcommand's or Maximize is probably what you are looking for. In the event used to open the report: DoCmd.OpenReport "ReportName", acViewPreview DoCmd.Maximize DoCmd.RunCommand acCmdZoom100 or... DoCmd.RunCommand acCmdFitToWindow Look up the other various Zoom sizes available in VBA Help.
