Brad,

I have done something similar to this and the way that I solved the problem
was to use code to change the size and position of the controls.  (Size=
width/height properties, Position=top/left properties).  However, using this
method you will have to manipulate the properties of each control.  Not a fun
task.

Another suggestion is to set up another set of forms for the lower
resolution.  This can become a real headache if you need to update the
interface because you will have two (or more) of every form that on which you
will have to make the changes.

I tried both methods and I liked the first one better.  It was a lot of work
up front, but saved me more in the long run.

HTH
Jason

this is not an access issue, it is an crt resolution issue
which mades it a hardware issue which is pretty fixed.
in access, you need to look at shrinking the form somehow.
this is a draw back for developing gigantic forms.

Hello Brad
The user should not have to scroll nor should a very large screen be a
requirement. I use two methods to overcome this:
A large amount of data can be usually be broken into logical groups which
can be displayed using a TAB control. On the Tab control I usually number the
tab captions such as &1 Address, &2 Contacts etc Using &n allows the user to
jump to the correct page using ALT N where n is the number of the tab. Tab 1,
the default tab, displays the most commonly used group of data. To use this
method you must know how each user or group of users is using the data.
A second method I have started to adopt, but which is a lot more work, is to
use a sidebar (like Outlook) which contains a list box (I tried Trees but
they are too slow) and a header which contains buttons, the equivalent of the
TAB pages but are the 'page' names of the 'sub' forms which are opened
stacked below each other. This allows the user to display the sections of
data required.
Using the second method you need to check the screen size and adjust the
forms to it and need to track which 'sub' forms are open so that when the
user clicks a different listbox item you can update the filters on each 'sub'
form.
HTH
Terry

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

FMS has a sizer module at www.fmsinc.com.

The Access Developer's Handbook has form resizing code included and you can
download an mde that you can use from the following URL
http://www.developershandbook.com/

Hi Brad,

Go to this website to see if that was what you're looking for.

http://3d2f.com/programs/13-377-access-form-resizer-download.shtml

Hope it helps.

Regards.
Roy