Form and display resolution

[shiro]

Hi all,have a good day..
My form not fit to some user's display.I think it's depending to the
display's resolution.How to set the form
auto fit to user's display.
Hope somebody like to help.

 

[Graham R Seach]

Shiro,

You're best just to redesign your form for a minimum resolution of your
users. In Access 2007, you can resize and reposition controls according to
screen resolution and other factors, but it's not something I'd recommend.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[John Keith]

Here is a trick I have discovered to allow developing on a screen set to a
higher res than your users, but allow you to qucikly see the size of a lesser
res screen.

This sets your access application window to a specific pixel size. I put a
button on my main menu to resize the application.

Private Declare Function MoveWindow Lib "user32" (ByVal hwnd As Long, ByVal
x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight As Long,
ByVal bRepaint As Long) As Long
Sub Appsize()
MoveWindow Access.Application.hWndAccessApp, 20, 20, 800, 600, 1
End Sub

 

[Graham R Seach]

I see your point. That's a clever idea.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[pddxxx]

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/ISBN=0782119417/107-8064361-7403703

Hope this helps,

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