Re-size form for larger screen

Hi,

I have created a database for a group of users who have different
screen/monitor sizes. On the larger screens, the main form 'overflows' at the
bottom of the screen so that the user is unable to see all the form. Is there
any way to modify access (on the machines with the larger screens) so that
all the form appears?

Pedro

Ken Getz has a resize control that can be used. However I can not post it
due to permissions, you can however use it if you have one of his Access
Developers Handbooks. Then you can freely use it because you bought the book.
--
Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness








"pedro" wrote:


Hi,

I have created a database for a group of users who have different
screen/monitor sizes. On the larger screens, the main form 'overflows' at the
bottom of the screen so that the user is unable to see all the form. Is there
any way to modify access (on the machines with the larger screens) so that
all the form appears?

Pedro

Pedro,

Resizing is always a problemchild when programming a db. Which size to go
for. I tend to choose the largest monitor resolution so the people who use
those don't have any issues. Point is when you take the lower resolutions as
a standard you are bound to program additional functionality to make sure
everyone can use it.

If you do want to use the resize functionality take a look he

http://www.mvps.org/access/general/gen0002.htm

Keep in mind that the result will always be different on whatever screen you
are watching.

hth
--
Maurice Ausum


"pedro" wrote:


Hi,

I have created a database for a group of users who have different
screen/monitor sizes. On the larger screens, the main form 'overflows' at the
bottom of the screen so that the user is unable to see all the form. Is there
any way to modify access (on the machines with the larger screens) so that
all the form appears?

Pedro

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/ss.htm

There's a form resizer at http://www.jamiessoftware.tk/resizeform/rf_jump.html
..

Another one: http://sourceforge.net/projects/modscaleform

The Access Developer's Handbook has form resizing code included:
http://www.amazon.com/exec/obidos/IS...064361-7403703

Hope this helps,

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