expand and retract form while open

[AccessARS]

I have a form which is being used to enter criteria of a report. While this
form is open I would like to have an "Advanced>>" command that would
drop/expand the bottom of the form with additional search options.

My attempt: I inserted a sub form with the additional search options on the
footer of the main form minimized in design view with the following
properties, can grow, can shrink and not visible. In the main form I set the
properties to can and can shrink. My expectations were to have the procedure
behind the command set the sub-form visible property to TRUE. Although the
Sub-Form appears the Footer does not expand therefore it overlaps. I also
placed it on the bottom of Detail but it just didn’t allow the sub-form to
grow or overlap.

Thank you in advance for your time.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[AccessARS]

Thank you...exactly what I was looking for.

Check out the docmd.movesize action in help. You can make form small or
bigger based on twips (1440- 1")

Damon