Ac2007 continuous form - expand on open?

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
Rick said:
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?
Click to expand...
 
Rick said:
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?
Click to expand...


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
 
I found the answer. Use DoCmd.MoveSize. Don't change the horizontal or
width, set the others.

.... rick
 
Back
Top