Where is the Form's height

[Guest]

Hi there,

My question is how can you control the size of the form, there is no height
property in property dialogue.Another question is how can i close the form in
open state in stead of switch to design view state


thank you so much for your help

clara

 

[fredg]

Hi there,

My question is how can you control the size of the form, there is no height
property in property dialogue.Another question is how can i close the form in
open state in stead of switch to design view state

thank you so much for your help

clara

From VBA help:
The Height property applies only to form sections and report sections,
not to forms and reports.

That being said, you can size a form (as well as position it on the
screen) using the MoveSize method in the Form's Open event:
DoCmd.MoveSize , , 3*1440,4*1440

The above will size the form at 3 inches by 4 inches.
All measurements are in Twips, 1440 per inch.

For more information see the MoveSize method in VBA Help.
Also the MoveSize action.

 

[Ron2006]

also, me.insideheight will give you the inside height of the
window the form is being displayed in.

 

[Ron2006]

also, me.insideheight will give you the inside height of the
window the form is being displayed in.

If you create a button and the instruction is:
docmd.close

It will close the current form

Or docmd.close "the name of the form"
will close the form being named.

or mouse the small little X box up on the upper right hand corner.

Ron