Resize SubForm and Main Form

I have a form with 10 little subforms which are 9cm wide and 0.6cm high.  They are placed on the form one after each other like the rows of a column.  When the user clicks on a field in a subform (called SubHeader), I'd like the subform to resize to 4cm high and for all the others to move down to make room.
Is this possible?
LudiqueAsked:
Who is Participating?
 
wiswalldCommented:
in the on enter for the subform put

Me.Subformname.Height = 4000   'or whatever you want
0
 
wiswalldCommented:
You will probably need something in the on exit also
0
 
monboisCommented:
To move the other subforms down you need to change their TOP property.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.