Access 2007 Forms Size

[piglet]

I cannot figure out how to keep Access 2007 from automatically
resizing forms to odd sizes. I have a shared database and when it is
opened in 2007, the forms are resized and saved to that size when
closed, without prompting. ??????

I can set it to tabbed - Ok for 2007, but in 2000 the forms are
resized and not viewable on some displays.

I need Access 2007 to stop screwing up my forms. HELP!

 

[George Nicholson]

Set the "Allow Design Changes" Property for each form to "Design View Only"

For overkill you could also do this: in the VBE, do a Find for "DoCmd.Close
acForm" or "DoCmd.Close" and set the 2nd argument (which applies to Design
changes, not data changes) to acSaveNo

I'm not running 2007 atm, but I assume these haven't changed.

HTH,

 

[Graham R Seach]

Hi piglet,

Set the form's [Auto Resize] property to Yes.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia