Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Resize SubForm and Main Form

Posted on 2008-06-21
3
Medium Priority
?
1,066 Views
Last Modified: 2013-11-28
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?
0
Comment
Question by:Ludique
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
wiswalld earned 2000 total points
ID: 21840968
in the on enter for the subform put

Me.Subformname.Height = 4000   'or whatever you want
0
 
LVL 13

Expert Comment

by:wiswalld
ID: 21840975
You will probably need something in the on exit also
0
 

Expert Comment

by:monbois
ID: 35223559
To move the other subforms down you need to change their TOP property.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question