Form size in 2007

[Chuck]

Hello,
I have a database created in Access 2003. When a user running Access 2007
opens it up some of the forms open about the size of a postage stamp. Even
though the boarder style is resizable the resize handle isn't available
making it un-usable. Any suggestions would be appreciated. Thanks Chuck

 

[ruralguy via AccessMonster.com]

I would set AutoResize to NO and AutoCenter to YES.

 

[pddxxx]

You can set the form BorderStyle property to Sizeable to get the
handles to resize the form.

I'm not aware of any Access 2003 to Access 2007 issues that would
shrink the size of a form. Is it possible that the other user has a
different screen resolution or DPI setting than your computer? If so,
you may want to consider some form rescaling solutions:

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html
..

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN=0782119417/107-8064361-7403703

Hope this helps,

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