adjust view

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have made a database that contains tables, forms and
queries and placed it on a shared drive for other people
to use.

The problem occurs when someone opens the database and
looks at the forms. The entire form does not "fit" on the
screen. Instead they have to scroll up and down and left
and right.

Is there a way to make the window adjust so it fits in the
view not only on my computer but on any computer the
database is used to open.

Thanks for the help
 
Sean said:
I have made a database that contains tables, forms and
queries and placed it on a shared drive for other people
to use.

The problem occurs when someone opens the database and
looks at the forms. The entire form does not "fit" on the
screen. Instead they have to scroll up and down and left
and right.

Is there a way to make the window adjust so it fits in the
view not only on my computer but on any computer the
database is used to open.

There are utilities and code you can acquire that will dynamically resize
forms, but I was never crazy about them. It seemed (for me at least) to
work pretty well to make forms larger than what they were designed at on
hi-res monitors (not your problem), but not so well on making forms smaller
than they were designed at on lo-res monitors. Also, sub-forms and certain
other objects don't resize as well as others.

I just design to fit a minimum standard (800 by 600) and leave it at that.
This is what many web designers do and there aren't too many 640 by 480
machines around any more.
 
There are third-party form scaling solutions available that might help:

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

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

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

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com
 
Back
Top