Form Size: Like tacking Jello to the wall

[oldblindpew]

I've just spent all morning (again) trying to get Access to let me size my
forms to suit myself. I open the form in Design view, use the mouse to
stretch the form to exactly the height and width I want, and then save it.
Oops, this doesn't work because MS doesn't regard this as a real change, so
it doesn't perform a real save. So I pick out some other form property at
random, like Autocenter, and change it back and forth, just to fool Access
into actually saving the form. Well, sometimes the form is saved exactly as
ordered, and sometimes not. Mostly, no matter how I adjust the size of the
form, Access decides I really don't need it that way, and it gives me
something else instead. Can anyone explain what is happening here?

 

[Dale Fye]

No, but I can tell you how to resolve the problem.

Determine the exact height and width you want the form to be. Then, in the
forms Open event, size it appropriately:

Private Sub Form_Open

me.insideheight = 4.25 * 1440
me.insidewidth = 6.0 * 1440

End sub

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dirk Goldgar]

I've just spent all morning (again) trying to get Access to let me size my
forms to suit myself. I open the form in Design view, use the mouse to
stretch the form to exactly the height and width I want, and then save it.
Oops, this doesn't work because MS doesn't regard this as a real change,
so
it doesn't perform a real save. So I pick out some other form property at
random, like Autocenter, and change it back and forth, just to fool Access
into actually saving the form. Well, sometimes the form is saved exactly
as
ordered, and sometimes not. Mostly, no matter how I adjust the size of
the
form, Access decides I really don't need it that way, and it gives me
something else instead. Can anyone explain what is happening here?

I usually set the AutoResize property to Yes, so the problem doesn't
arise -- then it's just a matter of setting the width of the form "canvas"
and the height of the individual sections in design view. However, if
AutoResize is set to No, I believe the trick is to open the form in *Form
View*, size the form the way you want it, and then click the Save button.

 

[Klatuu]

It helps if you set the form's Border Style property to thin (or something
other than sizable)