Designing Access apps for differing resolutions

[planetthoughtful]

Hi All,

Just wondering how others handle developing Access (2003) apps that
will run on a variety of different computers running at different
resolutions?

My impression is that Access doesn't really lend itself well to
resizing forms and fields on the fly, but if anyone knows of any tips
or tricks to achieve this I'd love to hear about them.

Much warmth,

planetthoughtful

---
"Lost in thought"
http://www.planetthoughtful.org

[John Mishefske]

planetthoughtful wrote:

Hi All,

Just wondering how others handle developing Access (2003) apps that
will run on a variety of different computers running at different
resolutions?

My impression is that Access doesn't really lend itself well to
resizing forms and fields on the fly, but if anyone knows of any tips
or tricks to achieve this I'd love to hear about them.

There are some freeware and commercial products to help with this. I think the Access
Developer Handbooks (for various Access versions) has code samples to do this.

I recall a ShrinkerStretcher product to do this ( http://www.peterssoftware.com/ss.htm I
believe) at a modest cost.

I'm sure if you search this group in Google Groups you'll see lots of suggestions and tips.

I tend to get the client to agree to a resolution, design to it with an eye to support
those resolutions close to the goal resolution without using any 3rd party solution.

--
'---------------
'John Mishefske
'---------------

[(PeteCresswell)]

Per planetthoughtful:

My impression is that Access doesn't really lend itself well to
resizing forms and fields on the fly, but if anyone knows of any tips
or tricks to achieve this I'd love to hear about them.

I've tried, but not had much success.

I just go around to each of the prospective users' PCs and check what screen rez
they're using (easier than asking... too many don't even know what it...).

1024 x 768 seems to work for most. If somebody's using less than 1024 x 768, I
bring that up as an issue. In the end, I design to whatever least common
denominator the clients agree to. 1200 x 1024 gives a lot more room though,
and I'll write to that if I can.

Writing OnResize() event code helps a little - and I usually do that when long
lists are presented... but that's about as far as I go.
--
PeteCresswell