Force form footer to appear under the last detail row instead of the bottom of the form

[samsquared]

I have a form that shows stocks I own and relevant info for each in the detail section like stock name, number of shares, price paid, and current value. The form footer contains several calculated totals but there's a lot of empty space between the last detail row and the footer. Is there a way to make the footer "float" and appear just after the last detail row?

[Micron]

No, but you can alter the height of the detail section via code according to the number of records you get. That will be resolution specific and won't necessarily look right on every screen. You could also put your calculations in the header instead - much easier.

[CJ_London]

if you are using overlapping windows you can adjust the height of the form window based on header height + footer height +(number of records x detail height)

if you are using tabbed documents then put your form in a subform and adjust the subform control height using the same formula

but personally I would favour putting the footer controls in the header section as Micron suggests - otherwise the footer will be jumping around. You can put a box round it to 'separate' it from the header information