We want to control the size of the form on which reports appear when opened.

DoCmd.OpenReport doesn't seem to be able to pass anything to control how it's opened and we can't see anything in the actual report that's usable. Was expeecting to be able to use something as simple as me.width=....

Any ideas?

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

You have to use a Report event. You can't pass these parameters to the report form the OpenReport event on your form. I think you have to size each section using twips (1440 per inch).

The best way to do this, however, is to make the report the size you want it, and while it is still open, set AutoResize to No, and then Save the report, while it is open. This will make the report open to that size unless a user resizes it and saves it.

Did that help?

If you want the report to open in the same position, do the same thing, but set auto center to No.




mmcdonal

Nice try, but that only works on a FORM and not on a REPORT.

Regards,

Sean Anderson

Hmmmm, I better tell Microsoft since that was directly from their Access Help file entitled:

Set the size and position of a form or report

Set the default size of a form or report

1. Open a form in Form view or a report in Print Preview.
2. Size the form or report by dragging the borders of the window.
3. Click Save on the toolbar.

You say it is not working then? I think sizing each section of the report, Header, Group Header, Details, Group Footer, etc is the answer then.

mmcdonal