Screen resolution problem

[Ronny Sigo]

Hello all,
Ik have made an Access application on my computer which has a screen
resolution of 1024 x 768. However the goal is to run it on my girlfriend's
computer which has a screen resolution of 800 x 768. Of course on her
computer not all of the controls are visible and she must scroll to see them
all.
Is there a way to adapt this automatically ?
Any help very much appreciated.
Ronny

[Mike Storr]

Re: Screen resolution problem

On Sat, 14 Feb 2004 15:52:25 +0100, Ronny Sigo wrote:
[color=blue]
> Hello all,
> Ik have made an Access application on my computer which has a screen
> resolution of 1024 x 768. However the goal is to run it on my girlfriend's
> computer which has a screen resolution of 800 x 768. Of course on her
> computer not all of the controls are visible and she must scroll to see them
> all.
> Is there a way to adapt this automatically ?
> Any help very much appreciated.
> Ronny[/color]

The only real way to adapt it is to design the forms for the smallest
resolution and then resize them for higher ones. Going the other way, you
may not get the form small enough when shrinking it.

That said, even when sizing for different resolutions, there is no
guarrantee that things will scale properly as different monitors and
different video adapters will handle scaling differently. Also, fonts don't
scale the same as graphics.

You can use the GetSystemMetics API (see
http://www.mvps.org/access/api/api0012.htm for an example) to get the
screen resolution, then you'll need to use DoCmd.Resize to change the form
sizes accordingly. You may need to move controls by changing thier Top/Left
properties after doing so.

--
Mike Storr
veraccess.com

[Sebastian C.]

Re: Screen resolution problem

"Ronny Sigo" <ronniesigo@sky ynet.be> wrote in message news:<402e3628$ 0$7028$ba620e4c @news.skynet.be >...[color=blue]
> Hello all,
> Ik have made an Access application on my computer which has a screen
> resolution of 1024 x 768. However the goal is to run it on my girlfriend's
> computer which has a screen resolution of 800 x 768. Of course on her
> computer not all of the controls are visible and she must scroll to see them
> all.
> Is there a way to adapt this automatically ?
> Any help very much appreciated.
> Ronny[/color]

Check this site:

http://www.jamiessoftware.tk

[David B]

Re: Screen resolution problem

There is something called Shrinkerstretch er downloadable from

http://www.peterssoftware.com/ss97demo.zip

which when I played with it, seemed to do what you want.
Other option you have is change the girlfriend to one that runs on a higher
res!!
DARFC
HTH
David B


Sebastian C. <sebastic@xnet. ro> wrote in message
news:9959a732.0 402141102.397fd c4f@posting.goo gle.com...[color=blue]
> "Ronny Sigo" <ronniesigo@sky ynet.be> wrote in message[/color]
news:<402e3628$ 0$7028$ba620e4c @news.skynet.be >...[color=blue][color=green]
> > Hello all,
> > Ik have made an Access application on my computer which has a screen
> > resolution of 1024 x 768. However the goal is to run it on my girlfriend's
> > computer which has a screen resolution of 800 x 768. Of course on her
> > computer not all of the controls are visible and she must scroll to see them
> > all.
> > Is there a way to adapt this automatically ?
> > Any help very much appreciated.
> > Ronny[/color]
>
> Check this site:
> http://www.jamiessoftware.tk[/color]

[Pat]

Re: Screen resolution problem

If you are using 2000 or 97, you might also look at the website for the
Access Developer's Handbook:

http://www.developershandbook.com/downloads.htm

About halfway down the page, there is a link to their form scaling/resizing
tool.

And since we are on the subject, the Access Developer's Handbook (insert
your favorite version here!) is, hands down, the most informative book about
Access.

Hope this helps you as much as it did me!
Pat

"Ronny Sigo" <ronniesigo@sky ynet.be> wrote in message
news:402e3628$0 $7028$ba620e4c@ news.skynet.be. ..[color=blue]
> Hello all,
> Ik have made an Access application on my computer which has a screen
> resolution of 1024 x 768. However the goal is to run it on my girlfriend's
> computer which has a screen resolution of 800 x 768. Of course on her
> computer not all of the controls are visible and she must scroll to see[/color]
them[color=blue]
> all.
> Is there a way to adapt this automatically ?
> Any help very much appreciated.
> Ronny
>
>[/color]