How to resize form automatically

[shirley Lu]

Our company computer monitor, some use 800X600 resolution, some use
1024X768.
How to use code to automatically resize form to fit differrent resolution in
Access 2000.

Thanks

 

[Jeff Conrad]

in message:

Our company computer monitor, some use 800X600 resolution, some use
1024X768.
How to use code to automatically resize form to fit differrent resolution in
Access 2000.

Hi,

You can add code to your forms that will resize all
controls to various screen resolutions. Here are some
links for you if you want to pursue that option.

1. Download an MDE file from the Developer's Handbook web
site. You can then reference that MDE in your application
to use the resize code.
http://www.developershandbook.com/

2. Purchase the Developer's Handbook for your version of
Access. In my opinion the book is WELL worth the money.
Not only do you get the resize code, but a wealth of other
information, code, and database samples. Go to the same
site listed above for more information.

3. Peter's software has a resizing utility at:
http://www.peterssoftware.com/ss.htm

4. The following link has also been posted as an alternative:
http://www.jamiessoftware.tk

5. FMS has a sizer module:
http://www.fmsinc.com.

6. Here is another possibility, but I have no experience
with this one either:
http://www.pdtech.co.uk/prod01.htm

 

[shirley Lu]

Call frmResize.SetDesignCoords(1024, 740, 96, 96)

Above call statement, When resolution is 800X600,
Do I need to change into:

Call frmResize.SetDesignCoords(800, 572, 96, 96)

or run this statement in 800x600, still keep like this:

Call frmResize.SetDesignCoords(1024, 740, 96, 96)

I designed the form in the resolution 1024x768.

 

[Jeff Conrad]

in message:

Call frmResize.SetDesignCoords(1024, 740, 96, 96)

Above call statement, When resolution is 800X600,
Do I need to change into:

Call frmResize.SetDesignCoords(800, 572, 96, 96)

or run this statement in 800x600, still keep like this:

Call frmResize.SetDesignCoords(1024, 740, 96, 96)

I designed the form in the resolution 1024x768.

Which code solution I provided are you using Shirley?
That looks like maybe ADH stuff you have there.
Are you using the MDE download version?

I have only used the code from the ADH (97 version) book
itself. The general recommendation is to develop at the lowest
resolution you want to use and then scale up, not down. So
for me, my code in the form's Open event looks like this:

Call adhScaleForm(Me, 800, 553, 96, 96, rctOriginal)

But this will of course be different depending upon what
version of the code you are using.