Reports Opening (Access 2000)

Topic

New Reply

I want a report to always open at 80% size. I ahve tried setting this and saving and also looked in properties for a settung to do this. Is there a way this can be set

Reply | Quote

Replies

Could you explain what you mean by 80% size? Do you mean you have the main Access window maximized and you want the report to come up in preview in a specific ratio to that window or what? There isn’t any way to set a percentage of size for a report, so I’m at a loss to know what you’re setting and saving. I personally prefer my reports to preview maximized so that the user doesn’t have to do a lot of scrolling to see a page.

Reply | Quote

Thank you for your reply. Yes this is what I was trying to achieve. What I did try was to set the ratio to 80% and then save the report again. It would seem then that there is no way of doing this. Thank you for your answer

Reply | Quote

If you use the OpenReport method from a form, you can use RunCommand to specify a zoom %. However, you can only ask it for one of the establish ratios; the closest to what you want is 75%. Your code would be:

DoCmd.OpenReport “yourReport”, acViewPreview
RunCommand acCmdZoom75

Reply | Quote

Thanks for jumping in, Mark. That’s an argument that I never saw much point in, so I forgot it existed.

Reply | Quote

I didn’t know about it, or had given it much thought, until a client asked for it. At 75%, the report is still readable and doesn’t require any left/right scrolling.

Reply | Quote