Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Low resolution screens hides some of the form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
M Skabialka - 15 Apr 2008 17:39 GMT
When I create Access databases I design on a monitor with very high
resolution so I can view multiple objects at once, but some of the users
have very low resolution so can't see an entire form, even when I have
thought I designed it small enough.
Is there a chart with some standard resolutions which will tell me what the
maximum width and height a form can be and still fit on the screen?  I do
not interact with these users so can not measure things on their screens.
Mich
pddxxx@gmail.com - 15 Apr 2008 18:03 GMT
If you size your form to 6 inches by 4 inches it should fit at 800x600
resolution.

You may also want to consider some form rescaling solutions. It's
possible to size your form to fit the end user's screen resolution.

A shareware version of a form rescaling module I wrote called
ShrinkerStretcher is available at this web site: http://www.peterssoftware.com/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html
.

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/ISBN%3D0782119417/107-8064361-7403703

Hope this helps,

Peter De Baets
Peter's Software - Microsoft Access Tools for Developers
http://www.peterssoftware.com
M Skabialka - 15 Apr 2008 20:29 GMT
The Shrinker Stretcher would be nice except these people use LoRes because
they can't see well!  If I shrink it then they can't read it!  6" x 4" is a
guess or realistic?
I am wary about downloading executables from foreign sites, so resizeform is
out, and modscale form was asking me to do product surveys so that's out.  I
don't have the Access handbook that's for sale on hand.
All I need is a scale:  Resolution vs size!

> If you size your form to 6 inches by 4 inches it should fit at 800x600
> resolution.
[quoted text clipped - 20 lines]
> Peter's Software - Microsoft Access Tools for Developers
> http://www.peterssoftware.com
pddxxx@gmail.com - 15 Apr 2008 23:11 GMT
> The Shrinker Stretcher would be nice except these people use LoRes because
> they can't see well!  If I shrink it then they can't read it!  6" x 4" is a
> guess or realistic?

It's realistic. You can always try changing your display settings to
800x600 or 640x480, then open your forms to see what will work best.
The ShrinkerStretcher demo also has some code to size the Access
window to the size of an 800x600 monitor. See the Maximized Form
Example in the demo - http://www.peterssoftware.com/ss.htm

Hope this helps,

Peter De Baets
http://www.peterssoftware.com
Rick Brandt - 16 Apr 2008 00:31 GMT
> The Shrinker Stretcher would be nice except these people use LoRes
> because they can't see well!  If I shrink it then they can't read it!
[quoted text clipped - 3 lines]
> surveys so that's out.  I don't have the Access handbook that's for
> sale on hand. All I need is a scale:  Resolution vs size!

Similar to what the other poster said I have found that if I keep forms at
around 4 inches tall and 7 inches wide (according to the design ruler) that
they will fit on 800 by 600 screens if Access is maximized.  This varies
according to how many command bars you are showing and whether the user is
using large fonts or different DPI settings in Windows.

Shrinker Stretcher (in my experience) is better at making forms larger than
it is at making them smaller.  The best thing to do is TEST and make all of
your forms fit on the lowest resolution you need to support.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

M Skabialka - 16 Apr 2008 14:07 GMT
4" x 7" is what I will strive for then.  Too bad as 5 x 10 fits so much more
information presented in an easily readable format.  I'm going to use tabs
to break up the info.
Thanks for all suggestions
Mich

>> The Shrinker Stretcher would be nice except these people use LoRes
>> because they can't see well!  If I shrink it then they can't read it!
[quoted text clipped - 13 lines]
> than it is at making them smaller.  The best thing to do is TEST and make
> all of your forms fit on the lowest resolution you need to support.
David W. Fenton - 16 Apr 2008 19:50 GMT
> The Shrinker Stretcher would be nice except these people use LoRes
> because they can't see well!

Tell them to get new glasses.

Seriously.

Or tell their manager.

It's ridiculous for someone to try to work with bad eyesight if it's
fixable (granted, things like cataracts are fixable, but generally
left until the get bad before being corrected, so this could be one
of those exceptions).

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

M Skabialka - 17 Apr 2008 16:24 GMT
These people are in their 70's and still working.  Glasses won't fix it.

>> The Shrinker Stretcher would be nice except these people use LoRes
>> because they can't see well!
[quoted text clipped - 9 lines]
> left until the get bad before being corrected, so this could be one
> of those exceptions).
David W. Fenton - 17 Apr 2008 23:35 GMT
> These people are in their 70's and still working.  Glasses won't
> fix it.

Then get them larger monitors.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.