Control Form Size in 2007

[Ross]

I can't seem to figure out, in Access 2007, how to keep the form size from
changing once that I have set it.

For example, if I size my largest form in the project with the navigation
pane closed, and then open the form with the navigation pane open, the form
gets squeezed down (to automatically allow for the navigation pane.

I have turned off everything, autocenter, autoresize, etc and tried modal
and pop up version of the form but nothing seems to lock the size that I have
set.

Why is this? How do I fix this?

Thank you much

Ross

 

[Mark Andrews]

You can put a little code in the Form_open event

example:
DoCmd.MoveSize 0.7 *1440, 0.7 * 1440, 8 * 1440, 6 * 1440

In Access Options:
Office button, access options, current database
you can choose overlapping windows or tabbed documents
This will affect how windows open.

Hope these tips help,
Mark

 

[Ross]

Hey Mark,

DoCmd.MoveSize 0.7 *1440, 0.7 * 1440, 8 * 1440, 6 * 1440

This is exactly what I needed. Exactly.

Thank you!!!