Setting permanent size & position of a form

  • Thread starter Thread starter freedomverse
  • Start date Start date
F

freedomverse

I need help with form size. I have looked over lots of previous posts and
still my forms are not cooperating.

I have a main form. On the main form there is a button that opens another
form. When the other form (which is a split form with the data sheet on
bottom) opens it opens too big. I have resized it and saved but the next
time it opens it is wrong again. It opens differently when opening it
manually than it does from the button on my main form. My question is this:
How do I tame this unwieldy form? I want it in the same place EVERY time.

Jared.
 
I need help with form size. I have looked over lots of previous posts and
still my forms are not cooperating.

I have a main form. On the main form there is a button that opens another
form. When the other form (which is a split form with the data sheet on
bottom) opens it opens too big. I have resized it and saved but the next
time it opens it is wrong again. It opens differently when opening it
manually than it does from the button on my main form. My question is this:
How do I tame this unwieldy form? I want it in the same place EVERY time.

Jared.
Click to expand...

If you always wish to have the form open in a particular position and
at a specific size, set the form's Auto Resize property to No. Set the
Form's Auto Center property to No.

Code the Form's Open event:
DoCmd.MoveSize 1.5 *1440, 3*1440,2*1440,1*1440

The above will position the form 1 1/2 inches from the left edge of
the window, 3 inches down from the top. The form will be sized 2
inches by 1 inch in size.
All measurements are in Twips, 1440 per inch.

Look up the MoveSize method in VBA help.
 
Thank you!! I thank you! My wife thanks you too - she was getting worried
that I was going to pull out all of my hair!!

Jared.
 
freedomverse said:
Thank you!! I thank you! My wife thanks you too - she was getting
worried
that I was going to pull out all of my hair!!
Click to expand...

That's a pretty painful way to take your mind off a form-sizing issue.

Larry
 
Back
Top