How can I make Access form fit anyone's resolution automatically?

[james_dean]

I made an inputting purposed form and want everyone to see all the fields in
the detail section. Some people have a very small resolution size and they
can't see all the fields without scrolling down. Is there a way to make the
form automatically fit the screen?

 

[Douglas J. Steele]

There's sample code to do this in Access Developer's xx Handbook by Litwin,
Getz and Gilbert et al (where xx is whatever's appropriate for the version
of Access you're using). You can learn more about their books at
http://www.developershandbook.com/

They've also produced an MDE version of the code that you can download from
http://www.developershandbook.com/downloads.htm and use in your application.

Another option is to purchase ShrinkerStretch from Peter De Baets
http://www.peterssoftware.com/

There's also code at http://jamiessoftware.tk/resizeform/rf_download.html
but I don't really know anything about it.