We help IT Professionals succeed at work.

Access Scroll bars for bigger forms

Murray Brown
Murray Brown asked
on
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."
Comment
Watch Question

Darrell PorterEnterprise Business Process Architect
CERTIFIED EXPERT

Commented:
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?
Remote Training and Programming
CERTIFIED EXPERT
Top Expert 2015
Commented:
hi Murray,

each control and form has a ScrollBars property that can be set to None (Help says 'Neither'), Horizontal Only, Vertical Only, or Both
Access form design, property, Scrollbars
Perhaps you can simply loop through the forms and change them to show scroll bars?

(btw, controls each also have a ScrollBars property)

Form.ScrollBars property (Access)
https://docs.microsoft.com/en-us/office/vba/api/access.form.scrollbars

If you don't have many forms and can change this manually, great -- or if there are a lot of forms and you can write VBA, great again! If you need code to iterate forms and open them in design view to change this property then save, just ask

kind regards,
crystal
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thanks
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
you're welcome, Murray!
Mark EdwardsChief Technology Officer
CERTIFIED EXPERT

Commented:
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.
Dale FyeOwner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010

Commented:

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.

Mark EdwardsChief Technology Officer
CERTIFIED EXPERT

Commented:
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....