Form resizing.

[TheOx2K]

I have a form with a command button and a subform on it. When the form is opened the subform is not visible and due to the size of the subform i have an area of blank form. When the command button is clicked i want the form to resize, the subform to be visible. I can get the sub form to resize but cant get the form to adjust itsseft so that the subform can be seen without using the scroll bars.

 

[Peter D]

You may want to consider toggling the subform control visible property from true to false, rather than resizing the subform.

You can use the

Docmd.runcommand acCmdSizeToFit

to size the form window to fit the form.

Hope this helps,

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