Datasheet Subform

[j]

I have a Subform that is in datasheet mode. I want to leave ample room for
a few rows and also room on the sides for the scroll bars. The problem is
that on records with a few entries I get the dark gray background showing
which makes my whole form look ugly. Any suggestions would be appreciated.

Thanks

 

[Wayne Morgan]

The easiest work around may be Continuous Form View instead of Datasheet
View.

You could resize the subform control to resize the window that the subform
is in, but I wouldn't know how to determine what size it should be resized
to. You can get the number of records in the subform's recordset and use the
average height of each row to make an educated guess, but the user can
resize these and that would mess up your calculations.