By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Screen resolution problem

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sat, 14 Feb 2004 15:52:25 +0100, Ronny Sigo wrote:
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


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
Nov 12 '05 #2

P: n/a
"Ronny Sigo" <ro********@skyynet.be> wrote in message news:<40**********************@news.skynet.be>...
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


Check this site:
http://www.jamiessoftware.tk
Nov 12 '05 #3

P: n/a
There is something called Shrinkerstretcher 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. <se******@xnet.ro> wrote in message
news:99**************************@posting.google.c om...
"Ronny Sigo" <ro********@skyynet.be> wrote in message

news:<40**********************@news.skynet.be>...
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


Check this site:
http://www.jamiessoftware.tk


Nov 12 '05 #4

P: n/a
Pat
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" <ro********@skyynet.be> wrote in message
news:40**********************@news.skynet.be...
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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.