sizing forms; STAY !

[barret bonden]

I have ,sadly, a customer who really cares about the size of the forms -
and worse , cares about extra "gray area" after the last
fields are shown

I've tried me.width = ####
and I tried setting it in properties.
and I've tried dragging it larger.

Nothing works - the form goes back to what it want to be -
Any way to make a form stay the size its told ?

 

[fredg]

I have ,sadly, a customer who really cares about the size of the forms -
and worse , cares about extra "gray area" after the last
fields are shown

I've tried me.width = ####
and I tried setting it in properties.
and I've tried dragging it larger.

Nothing works - the form goes back to what it want to be -
Any way to make a form stay the size its told ?

Look up the MoveSize method in VBA help.

 

[Rick Brandt]

I have ,sadly, a customer who really cares about the size of the
forms - and worse , cares about extra "gray area" after the last
fields are shown

I've tried me.width = ####
and I tried setting it in properties.
and I've tried dragging it larger.

Nothing works - the form goes back to what it want to be -
Any way to make a form stay the size its told ?

Have you tried setting the AutoSize property to Yes?

 

[BWD]

I have ,sadly, a customer who really cares about the size of the forms -
and worse , cares about extra "gray area" after the last
fields are shown

I've tried me.width = ####
and I tried setting it in properties.
and I've tried dragging it larger.

Nothing works - the form goes back to what it want to be -
Any way to make a form stay the size its told ?

I had this problem as well. Use the MoveSize method mentioned in the
previous post and remember ****If you maximize any other form while
the application is running it will maximize all the other forms in the
application regardless of any VBA in the class module. Write the code
for all forms and DO NOT maximize if you would like to keep the size
properties. This drove me crazy for hours before I finally got it!!

 

[Joan Wild]

If you size it while in Form View (even use Windows menu, size to fit form), then hit the save button, the size will be saved.