Controlling subform resizing

[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

 

[vbaInet]

Look into setting the Can Grow property to No of both the subform container and the textbox within the subform. Also set the Can Grow property of the sections in the subform to No as well.

 

[Deutz]

Thanks vbaInet,

That was exactly what I was looking for.

Rgds
Deutz

 

[vbaInet]

You're welcome!