Search code examples
ms-accessvbascreen-resolutionms-access-2000

Auto-Resize Form and Contents in Ms-Access


Background:

I am creating an application in Ms-Access that is to be launched on a multi-user platform - This means many screens and many different resolutions etc.

Question:

Is it possible to have my application that automatically adjusts to the right size of the screen/resolution and the font size to be proportional to that of the % increased or decreased?


Solution

  • Similar to my answer here, yes, you can use the On Resize event of a form to move controls around, change the size of subforms, and perform other similar operations. Those adjustments are applied to each individual object, so the coding would be somewhat tedious and a bit "fussy", but it can be done (at least to some extent).