Auto-Resize Form and Contents in Ms-Access

ms-access vba screen-resolution ms-access-2000
Justin picture Justin · Apr 17, 2013 · Viewed 11.3k times · Source

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?

Answer

Gord Thompson picture Gord Thompson · Apr 17, 2013

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).

Related questions

Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More
Get length of array?

I'm trying to get the length of an array, yet I keep getting this error: Object required Am I doing something wrong? Dim columns As Variant columns = Array( _ "A", "ID", _ "D", "Name") Debug.Print columns.Length ' Error: Object required

Read More
How to add default signature in Outlook

I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I add the default signature to …

Read More