ScreenResolution

[AccessAmateur]

How Do I find out what the screen resolution setting is? I am using MoveSize to position a form (used as a control box) on another form but if I position it correctly for a 1024x768 monitor is is irretrievably pushed off screen on an 800x600 monitor.

 

[Peter D]

Here's some code that might help:

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

Regards,

 

[AccessAmateur]

Using modules is new to me, how do I call this module from a VBA routine so that I can do something like:

Select Case Resolution

Case 800x600
MoveSize the form to location xy

Case 1024x768
MoveSize the form to location xy

etc

Thanks

 

[Peter D]

Select case xg_GetScreenResolution()
Case "800x600"
MoveSize the form to location xy

Case "1024x768"
MoveSize the form to location xy
Case Else
End Select

Hope this helps,

 

[AccessAmateur]

Worked like a charm. Thanks very much.