resizing forms accoring to the users screen size!

[hinser13]

I have a database that appears fine on my screen but viewing forms on other screens (users) not all the form fits the users screen!

Is there a way to ensure that the forms will fit any screen? is there any code that can resize a form according to the users screen resolution or screen size differences?

I have seen a screen resizer developed by a company, is this the way to go, however its £250! is there another way?

Thanks to anybody that can help.

 

[missinglinq]

Your problem is not with the screen size, which many people assume, but rather, as you hinted at, with the Screen Resolution. Adjusting for screen resolution is not an easy task. Fortunately, someone has already done the work for you! Go to this site and scroll down to the "Access Form Resizer" and download it. I've used it before without problems, and best of all, it's FREE!

http://jamiessoftware.tk/

You should note that this hack, like all hacks for this task, work best when the database is developed in the lowest screen resolution you're apt to encounter, and then upsize as needed.

Good luck!

Linq ;0)>