G
Guest
Dear MS-Access Community, is there a way to dynamically resize a subform
control containing a datasheet?
I have a subform that changes the quantity of displayed datasheet rows upon
selection of a combobox value located on the main form. Currently, the width
is set to accomodate a scroll bar when the rows are longer than the height of
the subform control; when the rows are shorter than the height of the subform
control, it displays a gray background on the left and bottom of the
datasheet.
I'd like to expand & contract the subform control to accommodate a variable
heigth & width. I understand how to programatically apply a set heigth &
width upon AfterUpdate of the combobox, but not how to interpret the required
dimensions.
control containing a datasheet?
I have a subform that changes the quantity of displayed datasheet rows upon
selection of a combobox value located on the main form. Currently, the width
is set to accomodate a scroll bar when the rows are longer than the height of
the subform control; when the rows are shorter than the height of the subform
control, it displays a gray background on the left and bottom of the
datasheet.
I'd like to expand & contract the subform control to accommodate a variable
heigth & width. I understand how to programatically apply a set heigth &
width upon AfterUpdate of the combobox, but not how to interpret the required
dimensions.