jpostuma
asked on
make subforms grow with forms
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
"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
ASKER
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.