Access Forms and Screen Resolutions.

[sanjay]

hi,

i initially designed forms using Aceess95/97 and by default the screen
resolution was 640x480 pixels. After upgrading to a higher processor pc, I
started developing Access forms (same database) under the 800x600 pixels
screen resolution using AccessXP.

The froms from the original database have shrunk under the 800x600 screen
resolution using AccessXP.

Is there anyway I can acheive uniformity so that all the forms acheive the
maximum coverage on the screen, as originally designed?

Also, which is the best screen resolution to use 1)640x480, 2)800x600
3)1024x768?

Thanks,

Sanjay Mehta

 

[Fred Boer]

Dear Sanjay:

Access cannot automatically adjust forms to different screen resolutions.
I've cribbed a response by Jeff Conrad from another post asking this
question:

<quote>

You can add code to your forms that will resize all controls to various
screen resolutions. Here are some links for you if you want to pursue that
option.

1. Download an MDE file from the Developer's Handbook web site. You can then
reference that MDE in your application to use the resize code.

http://www.developershandbook.com/

2. Purchase the Developer's Handbook for your version of Access. In my
opinion the book is WELL worth the money. Not only do you get the resize
code, but a wealth of other information, code, and database samples. Go to
the same site listed above for more information.

3. Peter's software has a resizing utility at:

http://www.peterssoftware.com/ss.htm

4. The following link has also been posted recently as an
alternative:

http://www.jamiessoftware.tk

BTW, the experts recommend developing at 800 x 600.

Jeff Conrad
Bend, Oregon

<endquote>

HTH
Fred Boer

 

[Jeff Conrad]

A couple more options to add to the list as well:

5. FMS has a sizer module:
http://www.fmsinc.com.

6. Here is another possibility, but I have no experience
with this one either:
http://www.pdtech.co.uk/prod01.htm

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Fred Boer" wrote in message