Blank lines at the bottom of a continuous form

[Miles R]

I have a continuous form showing data from a table which allows vertical scrolling as there are too many rows to show at once.
The form is for viewing only, set to Locked and not Enabled.

When I scroll to the bottom, I get blank rows which are unsightly and not needed. I never want to go below the bottom row.
Is there any way to stop Access scrolling below the bottom row? I suspect this is a "feature" that can't be changed.

Not a big deal, but will correct this if possible.

[mike60smart]

Hi
Can you show a screenshot of the Form in Design View?

[mike60smart]

I would suspect that you have expanded the Form Footer as shown in the attached screenshot.

[Welshgasman]

I think you would need to adjust the subform control to the minimum records that will exist?
I use a Goto Last, back 5 and goto last again to get this.

[Miles R]

Thanks for the replies. Attached is the form in design mode. The footer has zero height.
When I get to the bottom of the form and keep pressing the scroll bar down arrow, the form moves up and up until only the last row is shown at the the top. The rest is blank space.
Not sure why anyone would want to do this, but I suspect it is a design feature that can't be changed.

[Welshgasman]

This is my sub form and control.

[Miles R]

Thanks for the reply. Not sure I understand what you have said. The dataset has 46 rows but only 19 can be shown at once.
Scrolling is done entirely by Access itself, so there is no code involved. Not sure I would want to complicate things by putting code in place to scroll myself - which I think I have done elsewhere in another application.

[ArviLaanemets]

Without having to see your database it is difficult to give a good advice, but have you taken into account, that when you place a subform into form, then you have there subform control, which isn't your continuous form, but is a container object. And this container object contains your continouus form as source object. (Anytime I design something like this, I name the form as fFormName, an the subform as sfFormName to avoid having different objects having identical names used by Access when subform is created). Both those objects must be dimensioned properly - otherwise you may have problems.

[Miles R]

ArviLaanemets,

Thanks for the reply, but it is not a subform - it is a popup form. I have been having a private chat with Mike and sent him a small database that exhibits the issue. He reproduced the issue on his system and to quote Mike
"I believe this is the standard effect when you have a PopUp Form".

I am going to have to assume it is a feature - a rather annoying one nonetheless.

I will close down this thread as solved.

[Welshgasman]

Here is that subform as just an opened main form.
First pic is the form, second design view.
And if I was at all concerned, I could get rid of that little space at the bottom.
However, I think there would always be space for a potential new record?
The again, with a bit of an adjustment, I can get the third picture.

[Miles R]

Welshgasman,

Thanks for the reply. I am curious to know what happens if you press the down arrow button at the bottom of the scroll bar. Do the rows move up leaving more and more space at the bottom until only the last line (I assume 1752 is the last line) is now showing at the top, with everything else blank space.
Your scroll bar does not look the same as mine, so I assume you are not using Office 365 Access.

[mike60smart]

Hi Miles

Is the Form which has the problem a subform which is related to a Main Form ?

[Welshgasman]

Welshgasman,

Thanks for the reply. I am curious to know what happens if you press the down arrow button at the bottom of the scroll bar. Do the rows move up leaving more and more space at the bottom until only the last line (I assume 1752 is the last line) is now showing at the top, with everything else blank space.
Your scroll bar does not look the same as mine, so I assume you are not using Office 365 Access.

No, as my info states 2019.
If I click the down arrow anymore, I can get space for 4 extra records.

[Miles R]

Mike,
My form is not a subform, it is just a modal popup called from another modal popup called from the main form.

Welshgasman,
The fact that you get space for 4 extra rows is what I don't want. I think your form is editable and you can add rows. Mine in read only, so no rows can be added, so there is absolutely no point in having blank space at the bottom.
Ideally what I would have liked is for the form to scroll down to the end of the data, with the last row of data now at the very bottom of the form, with no space below it. It should not be possible to scroll down any more, just like you can't scroll up when you are at the top of the dataset.

Looks like I am going to have to live with this very minor cosmetic issue. I tend to be a perfectionist when it comes to my Access projects and having useless space at the bottom is not perfect.

I'll sign off from this thread now, unless someone has a magic bullet that will make this happen.

[Welshgasman]

That form is also read only, no additions/deletes. It is what I call an Emulated Split Form (ESF). It is linked to the main form and is used purely for record selection.

Seems you will just have to live with it then.