Open Form with specific Dimensions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database we use at work to track multiple items. I have it set to
maximze on the AutoExec macro so everything is maximized...obviously. I do
this as I use a lot of screeen space for all the data fields we display.

I would like to open a form through a command button and display specific
data only, but I do not want to have this "popup" form be maximized, I would
like to have it set to a pre-determined size. Any suggestions on how to
accomplish?

Thanks.
 
I have a database we use at work to track multiple items. I have it set to
maximze on the AutoExec macro so everything is maximized...obviously. I do
this as I use a lot of screeen space for all the data fields we display.

I would like to open a form through a command button and display specific
data only, but I do not want to have this "popup" form be maximized, I would
like to have it set to a pre-determined size. Any suggestions on how to
accomplish?

Thanks.
Click to expand...

Look up the MoveSize method in VBA help.
Code it's Open event:

DoCmd.MoveSize L*1440, T*1440, W*1440, H*1440

Where W is the Width of the form (in inches) and H is the height of
the form (in inches).

L and T are the left and top position of the fom on the screen.

All measurements, however, are in Twips (1440 per inch), so that is
why the measurements are multiplied by 1440.
 
Thanks fred,

However, I tried it and am not seeing it adjust the window size. I am
wondering if the Maximize Command in my AutoExec Macro is supersceding this
command perhaps?
 
If you've issued a Maximize command, that applies to every form in the
application.
 
Back
Top