Controling for sizing at open

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

Guest

I am having a problem controling the size in which my forms open. I am
noticing that when I have forms open that I have maximized and I have a
button to open another form that I want opened at a size of 3x2x4.5x2.5 that
the subsequent form opens maximized. How do I over write that to have my
other form open to the demensions that I have set up in the open macro?
Please help this is very frustrating.
 
I am having a problem controling the size in which my forms open. I am
noticing that when I have forms open that I have maximized and I have a
button to open another form that I want opened at a size of 3x2x4.5x2.5 that
the subsequent form opens maximized. How do I over write that to have my
other form open to the demensions that I have set up in the open macro?
Please help this is very frustrating.
Click to expand...

try this on load
DoCmd.MoveSize 100, 100, 8300, 6900 'play with the dimensions till you
get what you want

or set border style to dialog
 
I am having a problem controling the size in which my forms open. I am
noticing that when I have forms open that I have maximized and I have a
button to open another form that I want opened at a size of 3x2x4.5x2.5 that
the subsequent form opens maximized. How do I over write that to have my
other form open to the demensions that I have set up in the open macro?
Please help this is very frustrating.
Click to expand...

re: size of 3x2x4.5x2.5
I didn't know you could open a form in 4 dimensions.<g>

If 2 dimensions are satisfactory, in the open event of the new form,
code:
DoCmd.Restore
DoCmd.MoveSize 0, 0, 3*1440,2*1440

The above will place the form at the top left corner of the
application window and size it to 3 inches x 2 inches.

Look up MoveSize in VBA help.
All measurments are in Twips, 1440 per inch.

If, when you close this form you then wish to maximize the new window,
use DoCmd.Maximize, either in this form's close event or in the open
event of the next form.
 
Back
Top