CODEWITHSUNDEEP
formsms-access
Scottie
Scottie

Reputation: 11308

Access 2003 form borders won't stay sized correctly

I am working on an Access 2003 form and the borders keep resizing themselves so the form doesn't fit! It's driving me crazy! It seems to happen when I go into design mode. No matter how many times I drag the edges and save the form, it always seems to want to resize to some arbitrary size!

I have AutoResize turned off.

Any ideas why this happens or how to fix it?

Upvotes: 2

Views: 1018

Answers (2)

misterManager
misterManager

Reputation: 1174

When you enter design view, your border is probably larger than what you want it to be, and then once you exit design view into Form view again, you see the extra space.

A trick that helps me with that usually, is to size the window exactly how you want it (you will probably go back and forth between design and form view to make sure you like the size), and then go to design view one last time, hit save, go to form view again, and hit save again. Then close the form.

Also, I prefer to set the MinMaxButtons property to 'none' and the border style to 'dialog'. That way, users can't just jump in there and start resizing all of your carefully sized windows :)

Upvotes: 2

HansUp
HansUp

Reputation: 97101

If it's helpful, you can set the size and position of your form with VBA code in the form's On Open event.

In addition to controlling the position of your form, the Form.Move Method will allow you to set its size by assigning your values (in twips, where 1440 twips/inch) to the Width and Height parameters.

Upvotes: 2

Related Questions