Gap before continuous form footer

[Rod Behr]

I use continuous forms to populate a list. In the form header are search
criteria, in the form footer is a summary and continuous forms in the detail
section form "rows" if data.

When the search/filter criteria return a particularly short list, there is a
gap between where the list ends and where the footer starts. Is there any way
of raising the footer to meet the final row?

 

[Marshall Barton]

I use continuous forms to populate a list. In the form header are search
criteria, in the form footer is a summary and continuous forms in the detail
section form "rows" if data.

When the search/filter criteria return a particularly short list, there is a
gap between where the list ends and where the footer starts. Is there any way
of raising the footer to meet the final row?

You can change the form's InsideHeight property to make the
form shorter:

With Me.RecordsetClone
.MoveLast
If .RecordCount <= 13 Then 'max rows before scrolling
Me.InsideHeight = Me.Section(1).Height _
+ Me.Section(2).Height _
+ .RecordCount * Me.Section(0).Height
End If
End With