General discussion


Access Database - Automate Resizing?

By dirtycar74 ·
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...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by dryflies In reply to Access Database - Automat ...

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.

Collapse -

by dirtycar74 In reply to

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

Collapse -

by DeskTroll In reply to Access Database - Automat ...

you will need to code to do this so it may just be as easy to rework the forms.

look at

Collapse -

by dirtycar74 In reply to Access Database - Automat ...

This question was closed by the author

Related Discussions

Related Forums