Form footer not locked to detail section Access 2016 (2 Viewers)

[RaptorRaptur]

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

 

[isladogs]

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.

 

[arnelgp]

on design view, click on the subform, and on it's Property:

 

[DHookom]

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?

 

[CJ_London]

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

 

[CJ_London]

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

 

[Ken Sheridan]

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!

As you haven't responded to my colleagues' replies, we don't know whether you have achieved a satisfactory solution, If not, you have three options:

1. If you set the subform control's VerticalAnchor property to Top, when you resize the parent form the subform will retain its design size and position in relation to any other controls in the parent form's detail section, and a gap between the bottom of the subform control and the form's footer will increase or decrease.

2. If you set the subform control's VerticalAnchor property to Bottom, when you resize the parent form the subform will retain its design size and its position in relation to the form's footer will remain static. Consequently the position of its top edge in relation to any other controls in the parent form's detail section will vary as you resize the parent form.

3. If you set the subform control's VerticalAnchor property to Both, as arnelgp advised, when you resize the parent form the subform will be resized as you resize the parent form, so the position of its top edge will remain static in relation to any other controls in the detail section, and the position of its bottom edge in relation to the form's footer will remain static, provided that you do not reduce the size of the parent form to less than its design size.

My guess is that you want either 2 or 3, and probably the latter.

 

[RaptorRaptur]

As you haven't responded to my colleagues' replies, we don't know whether you have achieved a satisfactory solution, If not, you have three options:

1. If you set the subform control's VerticalAnchor property to Top, when you resize the parent form the subform will retain its design size and position in relation to any other controls in the parent form's detail section, and a gap between the bottom of the subform control and the form's footer will increase or decrease.

2. If you set the subform control's VerticalAnchor property to Bottom, when you resize the parent form the subform will retain its design size and its position in relation to the form's footer will remain static. Consequently the position of its top edge in relation to any other controls in the parent form's detail section will vary as you resize the parent form.

3. If you set the subform control's VerticalAnchor property to Both, as arnelgp advised, when you resize the parent form the subform will be resized as you resize the parent form, so the position of its top edge will remain static in relation to any other controls in the detail section, and the position of its bottom edge in relation to the form's footer will remain static, provided that you do not reduce the size of the parent form to less than its design size.

My guess is that you want either 2 or 3, and probably the latter.

Hi, Sorry about that. As it happened my reply was barred by the system as being possibly spam (I don't know what criteria it uses but I have has simple "thank you type messages as well as detailed technical discussions barred).
As it happened, I took the easiest way out. I took all the content that I had planned to go on the footer and placed it at the bottom of my main form, just below the end of the subform. This way I know that no matter how large or small my client's screen may be, at least the form will njot look silly.
I have not looked into most of the suggestions made as I was under time pressure and will only return to this issue if i am ever forced to use a footer.
Thank all of you for your valuable support
Regards
Alan

 

[RaptorRaptur]

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

Thank you, that is exactly what I have done

 

[isladogs]

Hi, Sorry about that. As it happened my reply was barred by the system as being possibly spam (I don't know what criteria it uses but I have has simple "thank you type messages as well as detailed technical discussions barred).
As it happened, I took the easiest way out. I took all the content that I had planned to go on the footer and placed it at the bottom of my main form, just below the end of the subform. This way I know that no matter how large or small my client's screen may be, at least the form will njot look silly.
I have not looked into most of the suggestions made as I was under time pressure and will only return to this issue if i am ever forced to use a footer.
Thank all of you for your valuable support
Regards
Alan

I explained the reason why some of your replies get blocked in a reply to your Profile post on Jan 9 but you didn't respond to that either. For reference this is your post & my reply:

 

[DHookom]

Hi, Sorry about that. As it happened my reply was barred by the system as being possibly spam (I don't know what criteria it uses but I have has simple "thank you type messages as well as detailed technical discussions barred).
As it happened, I took the easiest way out. I took all the content that I had planned to go on the footer and placed it at the bottom of my main form, just below the end of the subform. This way I know that no matter how large or small my client's screen may be, at least the form will njot look silly.
I have not looked into most of the suggestions made as I was under time pressure and will only return to this issue if i am ever forced to use a footer.
Thank all of you for your valuable support
Regards
Alan

Members with fewer than 100 posts are limited with what they post. This might even include the prohibited content in the post you are replying to.