modify form layout to different screen resolutions

[Peter De Tender]

Hi there,

Because of switching to a new TFT monitor, I'm forced to set my screen
settings to a higher resolution.

However, this "malforms" my Access forms; I can't develop my forms for
larger screens, as most of my customers have a regular 17" monitor with
resolution 1024 x 760 (correct ?)

I was wondering if there is a way to "stretch" or "shrink" my forms based on
the resolution of the hosting machine.

Regards,

Peter

 

[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.