Software

Ask something
Discussion Locked

Access Database - Automate Resizing?

0 helpful
4 replies

by dirtycar74

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access database that has forms that I'd like to re-size to a standard screen resolution. To make a long story short, the forms and almost everything about this database was designed prior to any ADA issues were in place, using a very large resolution (1600 x 1200) and now we have to make it useable by persons using a standard 1024 x 768 resolution due to ADA compliance issues.

Is there a way we can automate this resizing with Access or a third-party program? I'd rather not have to re-create all of the forms by hand...

4 replies

by dryflies

I do not know of a way to do this without some programming. For each of the items on the form, including the form itself will have to have its width,height,x,y, and font properties set as a function of the screen resolution. This can take place during either the load, open, or activate events. I think I would do it on open. If you don't want to do that, you can resize each of the elements of the form to fit the 1024*768 displays and leave it at that for all screens. I looked for the display properties but could not find how to get them programmatically but I know it can be done.

by dirtycar74

While this information is helpful, it does not fully answer the question satisfactorily. No points awarded at this time.

This discussion is closed to new replies.