Resizing of forms

[sanal]

All command buttons and labels on it are ok when the database is opened in my laptop. But the database is opened in desktop computer the labels on some command buttons are streched out and some portion of the labels not visible. How can it be prevented. How to prevent the un proportianate expansion of labels inside the command buttons on forms depending on the resolution of the computer it opened.Is this problem can be prevented by making the resizing ootion of the form to No.

[isladogs]

I believe Anchoring can do some of what you want but not everything

I use form resizing code by Jamie Czernak which modifies the form size to fit the screen size & resolution
There are other similar utilities available e.g. by ShrinkerStrecher by Peter's Software.

See the example database at: https://www.accessforums.net/showthread.php?t=69858

Hold the shift key down to view the code

To use in your own apps, copy the module modResizeForm and add the line ResizeForm Me to the load event of each form

[Missinglinq]

Your problem is caused by differing screen resolutions on the various machines you're using...and the two hacks mentions by @ridders52 are the most commonly used ones to address the situation.

It should be noted that these, and most such hacks, work best when upsizing, meaning that the app should be developed in the lowest resolution you're likely to encounter, when distributing it to users.

Linq ;0)>

[isladogs]

Linq makes a good point about upsizing

However although my resizing code is still based on upsizing from 800*600, it isn't necessary to do development work at that resolution.
My main monitor is 1620*1080 resolution, and my secondary monitor higher than that.
It just means that firms intended to be full screen in use, are smaller than that in design view.

NOTE I prefer to call my resizing code a solution rather than a hack