Problem with subforms

  • Thread starter Thread starter nartla
  • Start date Start date
N

nartla

Hello,

I am developping an application with VBA & Access. I created a form
containing 15 subforms controls (one above the other) , and I am
trying to make the subforms controls look good and all equals.

These controls are supposed to show each one a subform nammed
SF_MYSUBFORM that I have designed. It has 10 fields from left to
right. So I wish to have the form display the subforms controls
looking as if they were the rows of an array.

When I inserted the "subform controls" in the form, I used the control
situated in the Access toolbar. But each "subform control" has
different sizes (horizontal and vertical size) and I find it very
difficult to make them the same size, and space them correctly on my
form.

Is there a way for me to make the 15 subform controls automatically
take the size of the subform I have designed, so my form looks good ?

Thank you for your help.
 
Each SubForm control has a Width and Hight property. You can select all of
the SubForm controls at the same time and set these two properties the same.
 
nartla said:
I am developping an application with VBA & Access. I created a form
containing 15 subforms controls (one above the other) , and I am
trying to make the subforms controls look good and all equals.

These controls are supposed to show each one a subform nammed
SF_MYSUBFORM that I have designed. It has 10 fields from left to
right. So I wish to have the form display the subforms controls
looking as if they were the rows of an array.

When I inserted the "subform controls" in the form, I used the control
situated in the Access toolbar. But each "subform control" has
different sizes (horizontal and vertical size) and I find it very
difficult to make them the same size, and space them correctly on my
form.

Is there a way for me to make the 15 subform controls automatically
take the size of the subform I have designed, so my form looks good ?
Click to expand...


If you drag and drop the form object from the db window onto
your main form, access will try to size it for you. Check
to make sure it's the size you want, then select the subform
control and use Copy/Paste to make a second copy. Adjust
this second subform control's top property to the spacing
you want between each subform. Then use Paste 13 more
times.
 
Each SubForm control has a Width and Hight property. You can select all of
the SubForm controls at the same time and set these two properties the same.
Click to expand...

This is a great idea. I'll try it, as my form and subforms have been
already created.

Thank you to those who answered my question! :-)
 
Back
Top