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.
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.
I've a manuell programming for that.
But I think, Access can do it much better, including the text size.
Meanwhile ... we have Peter's ShrinkerStretcher ... a truly awesome product which I have used several times ... check out the fully functional demo ...