How to make this form... not as long? Opens up much bigger than needed 1

[MattGreer]

So here's a screenshot of the form:

All that space below the last record... any way to get rid of it?



Thanks!!


Matt

 

[dhookom]

Am I correct in assuming you want the window/form height to adjust based on the number of records displayed in the form? If there are more records, make the form higher automatically?

You can try code like the following.

Private Sub Form_Open(Cancel As Integer)
    Dim lngMargins As Long
    lngMargins = 1440   '1 inch
    Me.InsideHeight = lngMargins + Me.RecordsetClone.RecordCount * 400
End Sub

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[MattGreer]

That's right. I guess I'm confused why other forms don't behave this way tho? But then on other forms I have other elements, but, I don't know, it's just odd.

Thanks!!


Matt

edit: BTW, your website link is kinda, well, you probably already know.