Auto resizing of form

Hi,
Thanks Bernd for your help with my last query.

Could somebody please help me. Is it possible to
programatically change the size of the display ?
I Have made an access report on a 21" screen and most
people have a 17" screen! The guys with the smaller
screen have a lot of the form "cut off" ?

Les,

It is not the size of the monitor but the display resolution set by the user
that will cause what you're seeing. Here are two suggestions for code that
will allow your application to detect the display resolution and
rescale/resize forms:

You can download an MDE file that you can incorporate into your 97 or 2000
application from:
Form Scaling and Resizing Tool:
http://www.developershandbook.com/downloads.htm

The full source for this is available in the Access Developer's Handbook by
Ken Getz et al.

This utility is also recommended in the Access newsgroups: Peter's Software
Shrinker-Stretcher - http://www.peterssoftware.com/ss.htm

I have not used it so cannot comment on it.

hth,
--

Cheryl Fischer, MVP Microsoft Access



"Les" wrote in message
...
Hi,
Thanks Bernd for your help with my last query.

Could somebody please help me. Is it possible to
programatically change the size of the display ?
I Have made an access report on a 21" screen and most
people have a 17" screen! The guys with the smaller
screen have a lot of the form "cut off" ?

Thanks Cheryl, much appreciated
-----Original Message-----
Les,

It is not the size of the monitor but the display
resolution set by the user
that will cause what you're seeing. Here are two
suggestions for code that
will allow your application to detect the display
resolution and
rescale/resize forms:

You can download an MDE file that you can incorporate
into your 97 or 2000
application from:
Form Scaling and Resizing Tool:
http://www.developershandbook.com/downloads.htm

The full source for this is available in the Access
Developer's Handbook by
Ken Getz et al.

This utility is also recommended in the Access
newsgroups: Peter's Software
Shrinker-Stretcher - http://www.peterssoftware.com/ss.htm

I have not used it so cannot comment on it.

hth,
--

Cheryl Fischer, MVP Microsoft Access



"Les" wrote in
message
...
Hi,
Thanks Bernd for your help with my last query.

Could somebody please help me. Is it possible to
programatically change the size of the display ?
I Have made an access report on a 21" screen and most
people have a 17" screen! The guys with the smaller
screen have a lot of the form "cut off" ?



.