Screen Size

[Guest]

I have a form that on my 19" is perfect but when other users who have smaller
screens the form disappears of the bottom is there a way of auto resizing to
fit depending on screen size

thanks in advance

 

[BruceM]

I don't know about Access 2007, but versions previous to that do not have a
built-in way to resize. There are some utilities you can use. I have
posted some information below, but I have not checked the links in a while.
A search may turn up others. I have used the shareware version from the
developershandbook link, which works pretty well to resize to a higher
resolution (that is, design the forms to fit the lowest screen resolution),
but I prefer splitting the database and customizing the front ends.

You may want to consider splitting your database and devising modified front
ends for users with lower screen resolution/smaller screens. Here are two
links about splitting. There are many others.
http://allenbrowne.com/ser-01.html
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Resizing links:
http://www.developershandbook.com/
http://www.peterssoftware.com/ss.htm
http://www.jamiessoftware.tk

 

[Doc Rock]

Bruce,
How would you actually accomplish that? Would you have 2 FE's and tell
specific users to use FE1 and others the use FE2? Or, could you have a
batch file that senses the screen resolution (or is there some variable
in Windoze to query?) and call the particular FE?

Steve (delete the "at")

 

[BruceM]

Each user would have a front end installed on their own computer. The
articles in the links I provided in the previous posting in this thread
contain more information on that subject.
Consider a web browser, which is a portal to the internet, not the internet
itself. A front end is a portal to the data stored on the back end. In
some business situations users need limited internet access, maybe to just a
few sites. A web browser can be configured to allow users to go to those
sites and no others, and locked to prevent the users from making changes to
the permissions. There is in effect a customized "front end" for the
internet. From the user's point of view all that is needed is to open the
available browser.
Users don't choose the front end. They open the only one available on their
machines. Different front ends can be provided for any number of reasons,
from providing a different set of forms and so forth to providing a
different physical appearance. The main point here is that the user has
only one option.
The utility I used does somehow "sense" the screen resolution, but I don't
know how.