Resizing a form in MS Access

Question

I have created forms in Access but because of people's settings sometimes the form is small and sometimes it goes off the screen. I found an anchor command that seems to fill out the screen though the menu option is grey and I am using accdb.

But is there a command/setting to shrink a form???

Answer 1

No, there are no native methods for resizing a form. The Anchoring methods are for specific controls - you would select the control in Design view, and then set the anchoring properties. This works if you are designing in the lowest resolution you expect to encounter, but if you're designing forms on a high resolution system, and you'll be deploying to lower resolutions, your forms won't look right.

There are 3rd party utilities that do this, like Peter's Software ShrinkerStretcher (http://www.peterssoftware.com/ss.htm). I've used this in a few projects, and it works very well. It's not perfect, but it's the closest you'll get in the Access environment

Answer 2

I covered this subject thoroughly in my post http://www.devhut.net/2017/09/08/access-form-resizing-based-on-screen-resolution/ it has everything you need on the subject.