Long ago I found a post by a well known Access designer; can't remember who and darned if I've ever been able to find it again but it goes something like this:
- size the form in design view
- border type = resizable
- control box = no (if you leave it as default yes, a user can use the minimize, maximize or restore methods and mess up the size). This will also remove close button so form needs its own. You can right click on center of form header in form view for closing/saving etc. and add button later if you want to try steps first.
- remove vertical control bar (or both). Vertical reserves a strip of bar space that you can't get rid of.
- I initially set auto resize = no but found that once the border was set to thin, it didn't seem to matter. Resizing application & other forms had no effect.
- save form and switch to form view
- resize form width and save (you may have to repeat from this step if you don't end up with what you want first time)
- switch to design view, set border = thin and save
- CLOSE form - don't mess with width again while in design view
Open/close form a few times to test and should be OK if I got this right and it was followed correctly. All assumes single form view where all controls fit and the header, design and footer combined heights don't exceed the form area height. If it does, having no vertical scrollbar will be an issue. If you allow datasheet view, I don't know what effect that view might have. If you subsequently remove features like record selectors, it will likely introduce space you don't want, so take care of those options early. See if this works for you.
EDIT: I was able to do this without using the popup property. As far as appearance goes, all that seems to do is add a shadow to make the form look raised in the app window.
Last edited by Micron; 09-16-2018 at 08:04 AM.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.