Automatically resize MS-Access Applications
A major problem in the distribution of MS Access applications is the lack of scalability. Controls are not automatically adjusted depending on the particular resolution in Windows.
Thank you for your feedback. The Access team is currently looking into resizing Access applications, starting with forms. We will provide you with a notification when this is available, and will continue to work on additional resizing/zoom support within different areas of the product at a later time.
Jf Ruiz commented
Please, in any case implement this with an option at database level, not for the full Access application, so we could decide the behaviour of each acddb we open.
Any other solution will be a fatal mesh for already working development.
[Deleted User] commented
There's an excellent post on resizing based on screen resolution at https://www.devhut.net/2017/09/08/access-form-resizing-based-on-screen-resolution/ which covers the various options available to developers today. It's probably your best source of information on the subject.
Daniel Spooner commented
This would be great, it's a real shame form are set sized so I must design for the smallest monitor in the business instead of allowing for some level of dynamic sizing.
Even the ability to have subforms in a grid and either side by side or stacked depending on window size would be handy.
俊 和男 commented
Quiero hacer una BD de peliculas, pero grabadas en access, que debo dehacer??
I also have free code to automatically resize forms. This is based on open source code originally written by Jamie Czernik back in 2003. However it has been extensively updated since to allow for different monitor form factors, tabbed documents as well as overlapping windows and now also includes a zoom form feature.
For a full explanation, sample database and all necessary code, see my automatic form resizing tutorial at http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784
Hardy Edmilao commented
PCU University of Cambridge commented
SO lagging behind Excel / Word in this respect. Even a basic ZOOM function would help with accessibility.
Jeff Blessing commented
DPI Awareness is a joke, Microsoft seriously need to fix this, the fact that even the development environment of MS Access is broken by high dpi settings is laughable at best!
Simon Sheppard commented
It is not so much the resolution but changing the DPI to 120 or 150 will generally completely break the usability of an Access form.
Many users need to have larger text they can read so this is really a serious accessibility issue.
Ken Mulvihill commented
Anchoring has its limitation and is not useful for a data entry form with many controls including list boxes. Having to build your form for a laptop when 90% of your users are on 34" monitors is a waste of real-estate.
Ken Ismert commented
Implementing this suggestion implies building a true, working web front-end for Access. Modern browsers do the resizing thing really well.
@Brent Morris -- breathe deeply, and repeat "It's only a program, it's only a program..."
Phill Barnes commented
I use Anchoring for multiple controls, if you need multiple controls to size rather than just the one to fill the space, you can create a stacked arrangement of the controls and manually set each control to stretch in the direction you wish. As part of the same arrange they will distribute evenly.
Brent Morris commented
Bill G. needs to sh*t can the whole ACCESS team for NOT fixing this!!! - WTF. I hope that they burn in HELL...the HELL that they have created for everyone Else. You are worthless, your skill set IS worthless, your schooling IS worthless, your life IS worthless. You fix NOTHING and suck down a paycheck. You have NO value and your skill set has NO Value! MS Access management should just step in front of a moving BUS - and maybe someone would FIX this epic failure!!
Anchor property is often useful but has limitations - e.g. what if I want two (side-by-side) controls to increase in size (with the second control also moving to create space for the first) when the width of a form increases?
I developed my own tool to allow for much more flexible scaling/moving of controls on forms - demos and source code available here:
Robert Uscroft commented
What is the 'anker' property?
simply use the anker property, it works very good.