Form footer not locked to detail section Access 2016 (1 Viewer)

RaptorRaptur

Member
Local time
Today, 02:46
Joined
May 15, 2021
Messages
56
Hi Guys,
I have a form with a subform.
The detail section of the form currently has no data yet, just the subform. Everything is working except for the following:
No matter what I try I can't resolve this issue.
In design mode I set up the form which is not tall enough to fill an entire screen. In it I have the header area, the subform and the footer virtually touching one another. However when I open the form a gap appears between the detail/sub form bottom and the footer. This gap gets taller or shorter as I change the height of the window. It appears to be as if the footer is locked to the bottom of the window instead of the the bottom of the detail section!
It looks ugly and unprofessional.
Anybody have an idea how to solve this?

Regards,
Alan
 
Sounds like you are using tabbed documents display with layout guides and anchoring.
This adjusts the form to fill the screen.

Turn off layout guides. Use overlapping widows display
Alternatively, change the form to a popup.
 
on design view, click on the subform, and on it's Property:
anchor.png
 
Since you stated “ This gap gets taller or shorter as I change the height of the window“, it seems you are not using tabbed forms. As you change the height, which section do you think should change?
 
It is a form footer so appears at the bottom of the form, not just below the detail section

Not clear whether you have a single or continuous form but providing you are using overlapping windows or popup you can use code to set the height of the form.

Not at my computer but for a single form in the load event something like

Me.windowheight = section(acheader).height +section(acdetail).height + section(a footer).height

If a continuous form multiple the detail height by the number of records you want to display
 
Another option - since your main form is single move the subform in the detail to the footer and hide the detail section. Or move the footer controls to the detail section and hide the footer section
 

Users who are viewing this thread

Back
Top Bottom