Open and closing forms

I've had this problem too.

My solution was to create two global variables in a module

Global FormHeight
Global FormWidth


In the Forms load event insert the lines

Formheight = me.height
formwidth = me.width

In the forms open event insert the code

me.height = formheight
me.width = formwidth

This code gets the forms size when its first loaded and resets the forms size back to its original size each time you open it. You could also add variables for the forms top and left properties so you can place the form in the smae place each time it is openeed

If you want to get fancy use google to search for a form resizer. There are a couple of free VBA modules that will automatically scale all the forms controls when the form is resized. Thiese allow the user to resize the form to suit themselves.

I've had this problem too.

My solution was to create two global variables in a module

Global FormHeight
Global FormWidth


In the Forms load event insert the lines

Formheight = me.height
formwidth = me.width

In the forms open event insert the code

me.height = formheight
me.width = formwidth

This code gets the forms size when its first loaded and resets the forms size back to its original size each time you open it. You could also add variables for the forms top and left properties so you can place the form in the smae place each time it is openeed

If you want to get fancy use google to search for a form resizer. There are a couple of free VBA modules that will automatically scale all the forms controls when the form is resized. Thiese allow the user to resize the form to suit themselves.

Thankyou
I will try it now

I've had this problem too.

My solution was to create two global variables in a module

Global FormHeight
Global FormWidth


In the Forms load event insert the lines

Formheight = me.height
formwidth = me.width

In the forms open event insert the code

me.height = formheight
me.width = formwidth

This code gets the forms size when its first loaded and resets the forms size back to its original size each time you open it. You could also add variables for the forms top and left properties so you can place the form in the smae place each time it is openeed

If you want to get fancy use google to search for a form resizer. There are a couple of free VBA modules that will automatically scale all the forms controls when the form is resized. Thiese allow the user to resize the form to suit themselves.

Thanks
I tried it it complains about Height
the error says: "Method or data memeber not found"
should I use WindowHeight or insideheight instead

Please help

Use windowheight. This is the height of the form. Inside height is the height of the inside of the form subtracting the title bar and borders

Use windowheight. This is the height of the form. Inside height is the height of the inside of the form subtracting the title bar and borders

Can you tell me how can I open the form in it is full length at the start?

thanks