D doyle60 Aug 5, 2005 #1 I want to open a report in fit to screen. The code I found on the Internet didn't quite work for me. How is this done? Matt
I want to open a report in fit to screen. The code I found on the Internet didn't quite work for me. How is this done? Matt
R Rick Brandt Aug 5, 2005 #2 I want to open a report in fit to screen. The code I found on the Internet didn't quite work for me. How is this done? Click to expand... One difficulty is that the code to "fit to window" cannot be executed in the report's own code module. You have to call it in the same code that opens the report. DoCmd.OpenReport "ReportName", acViewPreview DoCmd.RunCommand acCmdFitToWindow I would usually include... DoCmd.Maximize ....in the Report's Open Event.
I want to open a report in fit to screen. The code I found on the Internet didn't quite work for me. How is this done? Click to expand... One difficulty is that the code to "fit to window" cannot be executed in the report's own code module. You have to call it in the same code that opens the report. DoCmd.OpenReport "ReportName", acViewPreview DoCmd.RunCommand acCmdFitToWindow I would usually include... DoCmd.Maximize ....in the Report's Open Event.
D doyle60 Aug 5, 2005 #3 Thanks so much. And thanks for the explanation. I did put it in the wrong place. Matt
