expand and retract form while open

A

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.
 
D

Damon Heron

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

Damon
 
J

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.
 
A

AccessARS

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

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

Damon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top