automatically size subform height

[tfullerton]

Does anyone know how to dynamically set the subform height based on the number of rows returned? The default view for my subform is datasheet and I want to see all rows returned by my subform without scrolling.

 

[Abulafia]

What happens if 100 records are returned? You'll struggle to fit this on screen and keep it legible.

While you can change the subform's height and you can count the number of records returned you are stuck with two problems:

1. How do you know what height to set a subform based on the height afforded to a record in Datasheet View and what happens to the parent form if you start messing about with the subform object's Height and Top properties?

2. Different users make use of differing screen resolutions - do you know how this will affect any code you write?

 

[tfullerton]

Actually, I don't mind if I have to scroll around the main form to see all the results of the subform, I just don't want to have to scroll inside of the subform itself. Max record count returned by the subform is expected to be less than 30 but can be as few as 5. I'm hoping to only mess with the subform's Height property, not its Top but I don't know much about it.