I had the same "problem" when I first started creating my database. There
are some third-party programs out there that will address this for you and
undoubtedly someone else will give you the URL to find them since I can't
remember it off the top of my head (one such is a program called
However, I'd like to share with you my experience in dealing with this
problem, which to me (at the time and still to this day) seems like
something Microsoft should have addressed when designing access. I tried
about three different third-party solutions and although some worked better
than others, in the end it is much easier and less stressful to just design
your forms in a low resolution mode and know it will always work in higher
Let me know though if you find a solution that's seamless and
"boomer" <email@example.com> wrote in message
news:firstname.lastname@example.org...> Question on formatting.
> I have two systems running my access database. On one screen I have
> managed to fit the form onto the screen without having to scroll up
> down or across, yet on the second system there is a large variance in
> the size and I have alot of scrolling to do.
> Does anyone know a trickto fit a form to a single page either on the
> design view or the form view. I have managed to shrink the form on one
> database, but on my original screen it is now too small. I am sure its
> something basic, but I am at a loss to do it.
> The microsoft help is as useful as always, so I'm polling true users
> for this tip. Thanks in advance for your help!