Resizing the Window of a Form

[pyropowers]

I am trying to set the windows size of a form when it opens. It is a continuous form and on autoresize it ends up only showing one record at a time. I want to have no border. When it opens, if i had set it to have a sizeable border, I can resize and it will show more than one record. I plan on counting the records in the form and having the height change based off of that, up to a certain size. I have tried turning off autoresize and under the on open event using acCmdSizeToFitForm, but no luck. Any help is greatly appreciated, thanks.

[MSeda]

in the on open event set the form's insideheight to the the height of the detail multiplied by your record count plus any header or footer height.

the statement will look more or less like this

dim reccnt as integer
dim dethi as integer
 
dethi =320
rccnt = ???
 
me.form.insideheight = dethi*reccnt + me.formheader.height + me. formfooter.height
 
 

you'll need to flesh it out by setting the record count variable, you can use an if statement to limit the size.
This should get you started, see where it takes you and post back

[pyropowers]

Thanks a lot, its working now.

in the on open event set the form's insideheight to the the height of the detail multiplied by your record count plus any header or footer height.

the statement will look more or less like this

dim reccnt as integer
dim dethi as integer
 
dethi =320
rccnt = ???
 
me.form.insideheight = dethi*reccnt + me.formheader.height + me. formfooter.height
 
 

you'll need to flesh it out by setting the record count variable, you can use an if statement to limit the size.
This should get you started, see where it takes you and post back