Assuming that you're wanting to control the height of a continuous form?
The short answer is no. You can set the form's Border Style property to
'Sizable' to allow users to resize it when it is displayed. But, if you are
really determined, then my general philosophy of "you can do anything if
you're bloody-minded enough" can be put into action. No detail, but the
approach would be:
Determine how many records are to be displayed (via
Me.RecordsetClone.RecordCount)
Calculate how big your form would need to be to display that many
records
In the form's Load event (the Open event will be too early), run code
using the DoCmd.MoveSize method to resize the form
You might also want to limit the size so that the form doesn't get too big
for the screen.
Have fun,
Rob
