Form resizing

[Ian Bayly]

I have a client with a number of recalcitrant users who insist on keeping
their screen resolution at 640 x 800 running a series of Access forms
designed to fit a 1024 x 768 (or better) screen resolution.
Is there a technique whereby I can test the resolution and scale the form
(or Window with API call) such that the form (window) will fit on the screen
regardless of resolution.

TIA

Ian B

 

[Cheryl Fischer]

The Access (your version) Developer's Handbook by Getz et al has code which
you can add to your database to do this. I believe you can also download
this code in an MDE which can be used w/ your application from
http://www.developershandbook.com/downloads.htm

I have also heard that Shrinker/Stretcher is pretty good -
http://www.peterssoftware.com/

 

[Ronald Dodge]

In addition to the sites that Cheryl Fischer has provided, you can also go
to:

www.jamiessoftware.tk

This is where I got the code from, though I also did some adjustments to his
code to fit my needs, which overall, the adjustments I did had mainly added
additionals enhancements to it.

 

[TC]

Scaling up usually looks ok. Scaling down might not.

TC