Print Preview difference in Access 2003 over Access 2000

[Ron]

Hi,

When I use access 2000 to run a database I've designed, the print preview is
almost a full page view... right out of the box. Didn't really have to do
anything to get that. It just was/is.

When I run the same database in Access 2003 the print preview is less than
half a page, and the size of the report is automatically "fit", so all the
printing is very small and nothing can be seen except perhaps just the
layout of what will print, not the actual report--way too small. So, the
user must click on the preview to get it bigger, then drag the left/bottom
borders down, over so that they can see the actual report. Close that
window and next time it's run, it's back to the small version again so the
user must manipulate the percentages again (100%) and drag borders, etc.

Any way to permanently set these in print preview?

Thanks for any help,
ron

 

[Arvin Meyer [MVP]]

Try this as your openreport code:

Private Sub cmdPreview_Click()
DoCmd.OpenReport "rptReportName", acViewPreview
' Maximize the window
DoCmd.Maximize

'The number at the end represents the % zoom
'You can use other values that are not in the dropdown
'DoCmd.RunCommand acCmdZoom100
End Sub

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Ron]

Hi Arvin,

Yup, that did the trick. I knew a solution would be somewhere in Access'
capabilities. After trying your suggestion out I discovered DoCmd.Movesize
which allowed me even more flexibility than Maximize gave me. GREAT STUFF!

Thanks! I appreciate your time and expertise!
ron