Gap before continuous form footer

  • Thread starter Thread starter Rod Behr
  • Start date Start date
R

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?
 
Rod said:
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?
Click to expand...


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
 
Back
Top