Solved

make subforms grow with forms

Posted on 2009-04-02
4
509 Views
Last Modified: 2013-11-28
Hello,
I have a form wich contains a subform.
I am having troubles with auto resize in regards to widescreens and normal screens.
The parent form fullscreens upon open.

The trouble that I'm having is when the parent form fullscreens in a widescreen, the subform does not and just looks stupid.
(it is left to right)
Is there a way to have my subform's 'grow' with the parent form?

thanks.
0
Comment
Question by:jpostuma
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 125 total points
ID: 24055287
You might want to look at this:

http://www.peterssoftware.com/ss.htm

It covers ALL cases of forms, subforms, subforms inside of subforms.  I have it and it works very well.

mx
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 125 total points
ID: 24055554
When you say "FullScreen" do you mean "Maximized"?
Or do you mean your forms are openig full screen as "Tabbeded" forms (Then new View in Access 2007)

In either case the form is soiply "Opening" not "Growing" so the subfrom will remain the same size.

Your goal when designing your forms should be to make it loook god in any resolution.

Since you are using Access 2007, you should really investigate all the  new "Anchoring", sizing and positioning options for forms.
Forms  controls can now grow dynamically when resized.
Similar to the way a web page will grow or shrink when you adjust any webbrowser elements (Like making the Favorites pane wider or narrower.)

;-)

JeffCoachman
0
 

Author Comment

by:jpostuma
ID: 24055894
thanks to both of you.
I'm just going to split the points.
that program looks sweet, and anchoring works great.

Jeff:
is there any sort of anchoring system that can work with datasheet view?
I've tried, but to no avail.
I have subforms that are in datasheet view, and they stretch fine, but the columns stay the same size.

anyways, don't mean to make you guys answer more than one question, but I would apprecieate it.
Thanks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24057965
jpostuma,

"is there any sort of anchoring system that can work with datasheet view?"
Not that I know of.
The question is; if the Datasheet form is designed so that the entire filed is visible, then why would it need to grow?
Perhaps the link MX posted will mainipulate the subform in this way though...

"don't mean to make you guys answer more than one question"
LOL!
As MX will tell you, "Follow-up" questions are fine.

The problem arises when the "follow-up" question requires a different train of thought.

Good Follow up question example:
Original question: How do I view two columns in a combo Box?
Answer: Include the second column in  the rowsource and Set the Column Width Property to: 1,1
Follow up question: How do I sort by the second column?
Answer: set the Row source to: SELECT Col1,Col2, FROM Table ORDER BY Col2
;-)

Not-so-good Follow up question:
Original question: How do I view two columns in a combo Box?
Answer: Include the second column in  the rowsource and Set the Column Width Property to: 1,1
Follow up question: How do I make this combobox automatically add values?
Answer: This should be posted as a New question.

As you can see, from the askers standpoint the followup is "related" to the original question becaues it still deals with the combobox.
From an answering perspective, making a combobox add values requires a totally different approach.

;-)

Jeff
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help writing a query 6 70
Before insert Image (OLE) resize image 11 41
subtract 1 in Access 2003 query 7 36
Run Time Error 3071 26 34
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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 “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now