Controlling subform resize

[Deutz]

Hi and thanks in advance,



I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data.

Thanks
Deutz

[June7]

Do you have the subform ScrollBars property set to Neither? Will never have more records than can be displayed in the sized subform - no need for vertical scroll?

[Deutz]

Yes Scrollbars property is set to neither.

Someone just suggested to me that I set the Can Grow property to No for the container and subform textboxes and detail section and that has seemed to work so thanks for your reply June7.