What is the VBA statement to determine the size of the user's screen
(monitor)? I am interested in the size of the screen (15", 17", 19", etc.)
rather than the screen resolution so that I can create an alternative form
that will be called when the user's screen size is 15" or smaller (for
example on a laptop). I will have one form that is optimized to fill the
screen of a 17" monitor or larger and an alternative form that will be
called when the screen size is 15" or smaller.

I know that it is probably impossible to determine the screen size as 15",
17", etc., but there must be a way to determine the width and height of the
screen in pixels (or inches), and from that information I can have my code
choose the correct form for the screen size.

Thanks for your help?

BobV

There is no link between physical screen size and resolution. There's
nothing to stop someone with a 21" monitor running it at only 640*480, for
example.

Whilst there is no way to determine physical screen size, you can determine
screen resolution (and lots of other things) from the GetSystemMetrics API
call: see http://www.mvps.org/access/api/api0012.htm for an example.

There is a related issue: Access uses 'twips' for dimensions, there being
1440 twips per inch. However, these are logical, not physical, dimensions: a
textbox 1440 twips wide won't usually be 1" wide when measured on screen
(with a ruler). The screen is usually set up to be logically a bit wider
than a piece of paper, even though physically, it could be any size. For
instance, my screen is logically 10.6" wide, but its physical width is about
12.6".

-----
Simon Lewis