Form View Question

[Anthony Lisanti]

What is the setting to make a form not maximize, but only open to a
specific size? Example, if my form only has 5 buttons, I don't want
the form to maximize on the whole screen, just open up to the size I
want.

I've done this before, but I forget the property settings for this.

Thanks

 

[Ken Snell \(MVP\)]

In the form's Open event, run this code step:

DoCmd.Restore


You can set the size of the form in Design view. Open the form in Design
view, click the Restore button, and size the form to the desired dimensions.
Save the form while it's in Restore mode.

 

[Anthony Lisanti]

Actually, the problem was in my macro. I selected Maximize window.

Shutting that off get's the result I want.


Your suggestion looks like VBA code. I'm a beginner with Access, so
it's not needed.