form sizing

  • Thread starter Thread starter george
  • Start date Start date
G

george

Hi,
Is there a way to programmatically control the size of a
form so that it resizes every time it opens, so as to
occupy all available space on screen? Will this code be
effective even if I run my program on another machine with
different screen size or resolution?
 
George,

Use the On Open event of the form to run the following line of code:

DoCmd.Maximize

This will maximize the form within the Access window. If you want to
maximize the Access window itself, then use:

DoCmd.RunCommand acCmdAppMaximize

HTH,
Nikos
 
There are third-party form scaling solutions available that might
help:

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

FMS has a sizer module at www.fmsinc.com.

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 - MS Access Tools for Developers
http://www.peterssoftware.com
 
Back
Top