The amount of space that the interface for access takes up on your
screen has nothing to do with the size of your screen. When you got
the new monitor it was probably set to a different resolution than your
old monitor. A normal resolution is 800 X 600 or 1024 X 768. 1024 X
768 is probably more the industry standard nowdays. You should be
creating forms to that resolution.

You can change your resolution or find out what it is by right clicking
on your desktop - then clicking on properties - then click on the
settings tab of the dialog box that comes up.

On that dialog box you will see a control that says screen area - It
should tell you what resolution you currently are using and allow you
to change it.

If you want to take up more real estate on your screen you can maximize
your forms, but that fills the screen with blank space in most cases.
Otherwise you will need to change the size of your forms and the
controls on the forms. The amount of space taken up by your interface
shouldn't be the controlling factor though as long as you are getting
all the info you want on the screen.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/