Ac2007 continuous form - expand on open?

[Rick]

I have a continuous form with a Form Header, Details and Form Footer
(empty). When the form opens it is centered on the screen and shows the Form
Header but only one line of Detail.

Is there a way to expand the form vertically (not horizontally) so that it
fills the screen exposing many more detail records?

Thanks.

... rick

 

[SDCT]

I have a continuous form with a Form Header, Details and Form Footer
(empty). When the form opens it is centered on the screen and shows the Form
Header but only one line of Detail.

Is there a way to expand the form vertically (not horizontally) so that it
fills the screen exposing many more detail records?

Thanks.

.. rick

You could put DoCmd.Maximize in the Form's open event... or, if you
don't want it maximized, expand the form's window size vertically (not
the form sections, but the actual window) in form design view.

 

[Marshall Barton]

I have a continuous form with a Form Header, Details and Form Footer
(empty). When the form opens it is centered on the screen and shows the Form
Header but only one line of Detail.

Is there a way to expand the form vertically (not horizontally) so that it
fills the screen exposing many more detail records?

 

[Marshall Barton]

I have a continuous form with a Form Header, Details and Form Footer
(empty). When the form opens it is centered on the screen and shows the Form
Header but only one line of Detail.

Is there a way to expand the form vertically (not horizontally) so that it
fills the screen exposing many more detail records?

You should be able to make the form the desired height in
design view and then save the design,

It would take some API code to determine the available
height in the Access window. If you want to pursue this, I
think there might be an example at www.lebans.com

 

[Rick]

I found the answer. Use DoCmd.MoveSize. Don't change the horizontal or
width, set the others.

.... rick