Form Sizing

[Samantha]

I have a command button on my form that opens a report.
The report is set to open maximized. After the report is
opened, all of the forms then change to maximized. How can
I make them remain their original size? I have already set
the auto resize to no and I have tried to change the pop-
up option to "yes" but then you can't see the report.
Any suggestions?
Thanks,
Samantha

 

[Marshall Barton]

I have a command button on my form that opens a report.
The report is set to open maximized. After the report is
opened, all of the forms then change to maximized. How can
I make them remain their original size? I have already set
the auto resize to no and I have tried to change the pop-
up option to "yes" but then you can't see the report.

Two ways that address this issue. One is to add a
DoCmd.Restore line of code to the report's Close event.

The other is to configure the forms so that they can't be
maximized. This is done by disabling their Min/Max buttons
in the form's property sheet.

 

[Peter De Baets]

Try putting a

DoCmd.Restore

.... in your form OnActivate event procedure.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com