Determine screen "size"

J

John D

My application will run on a number of different computers - which means a
number of different physical screen sizes, resolutions, etc.

My general question is - is there a way to determine physical screen size
and screen resolution settings to size windows (forms, reports) so that they
will appear within the available visual space?

Specifically, I have a list box on a form that contains report names. The
user can click a report name and view a preview of the report. I use the
DoCmd.MoveSize method to position and size the preview - but it will extend
beyond the edge of visual screen space for some "smaller" screens/less
"dense" resolution settings, and will be visually smaller than necessary for
larger screens/more "dense" resolution settings.

Any solutions? Thanks - John D
 
A

Al Campagna

John,
Usually, resizing is associated with forms, because report preview can Zoom In/Out.
If you do a Google search (or Google Access Newsgroups) on "microsoft access" "resize"
"forms" you'll find many hits, and those hits will show you how to "call" to Windows to
get the screen resolution.
Once you've determined that, you should be able to open the reports, and use the
RunCommand acCmdZoom values to give you the correct "initial" view of the Print Preview...
rather than Move Size. (Whichever method works best for you...) See Run Command
Constants.

This is AirCode....
If Resolution = 800 x 600.... Then
DoCmd.OpenReport "rptXYZ", acViewPreview
DoCmd.RunCommand acCmdZoom75 (or some other Zoom size)
Elseif Resolution = 1024 x 768 Then
etc... etc....

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
J

John D

Thanks Al - good tips - I'll pursue.

BTW - what does "hth" mean? I see it used in postings a lot, and I wonder if
any of my hypotheses is "it".

Thanks - John D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top