Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access Scroll bars for bigger forms

Hi. I have been asked to do the following by a client on my Access forums. Is this viable?

"Please investigate adding scroll bars to large forms. On a standard 13-inch laptop some are so tall that they hide the bottom row of buttons. BUT we won’t go ahead if it’s difficult or time consuming."
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

Okay - simple Google search resulted in the VBA reference for Access scrollbars - https://docs.microsoft.com/en-us/office/vba/api/access.form.scrollbars

Do you have sample code/accdb file to see the issue?
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Thanks
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome, Murray!
One tip for forms that are longer than the screen is tall - put your buttons on the form header or footer, as these stay in place while the detail section scrolls up and down.

You never "scroll" your buttons away out of sight.

I detest forms that require scrolling.  As Mark said, put the buttons on the form footer, then use the tab control and group your data in logical groupings on those tabs.

As we get more and more into clients who want applications that behave more like web pages (complete with scrolling, etc - I've had a few...), knowing how to design an Access form to look and behave like a web page comes in real handy.

I've had clients who what the "look and feel" of a webpage because their employees know how to handle them (cuts down on training time, etc.)

Don't know if the author is trying to design this way, or it just happened....