M Marshall Barton Apr 24, 2009 #2 Rita said: Could someone tell me how to set the preview to 100% and not fit? Thanks! Click to expand... I usually put this right after the OpenReport method: DoCmd.RunCommand acCmdZoom100 Check VBA Help for RunCommand to see the other zoom options.
Rita said: Could someone tell me how to set the preview to 100% and not fit? Thanks! Click to expand... I usually put this right after the OpenReport method: DoCmd.RunCommand acCmdZoom100 Check VBA Help for RunCommand to see the other zoom options.
A Al Campagna Apr 24, 2009 #3 Rita, From whereever you call the Report... DoCmd.OpenReport "Report1", acViewPreview DoCmd.RunCommand acCmdZoom100 Check out RunCommand, and RunCommand Constants in Help. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
Rita, From whereever you call the Report... DoCmd.OpenReport "Report1", acViewPreview DoCmd.RunCommand acCmdZoom100 Check out RunCommand, and RunCommand Constants in Help. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life."
