Dynamically resizing forms & Controls

[DeanEdwards2012]

Hi all,

I have an issue with the database im making that i hope someone can help me out with.

Im making a database that will be used by multiple people on a network, and they have different resoloutions on their own computers. when the database is loaded on their respective computers, the form controls are all off.

On the computer i designed them on, the forms fit perfectly on screen, as do the controls, i would like to know if there is some vba code i could incorporate into the form open event, or module code that i can use in order to dynamically re-seize the forms and all of the controls to suit different resoloutions?

Thanks in advance

Dean

p.s. still learning, so crayon version in big letters if possible. Thanks

 

[CJ_London]

It depends on how much of an issue it is, but you can use the form Resize event to adjust the position and size of controls. However if you also have to adjust font sizes as well it becomes more complicated.

There is a package you can buy http://www.peterssoftware.com/ss.htm

 

[DeanEdwards2012]

OK, so there is no way to impliment code on the form without another program?

thanks

 

[missinglinq]

...so there is no way to impliment code on the form without another program...

Sure, the add-in CJ gave you a link to is done with code, but it is a very complicated process, which is why everyone uses the one or two hacks that are out there instead of reinventing the wheel! I've been developing Access databases for 15 years, and I wouldn't even think about trying to code this myself!

From that same site is another shareware program that performs the same task. Go to the site and scroll down to the "Form Resizer" and download it. I've used it before, with versions 97-2003, without problems, and best of all, it's basically free! They ask for a $5-10 donation, if you find it useful.

This program, like all of those out there, work best when you are re-sizing upward, so the development should be done in the lowest resolution you're likely to encounter, in distributing it.

http://jamiessoftware.tk/

Linq ;0)>

 

[CJ_London]

OK, so there is no way to impliment code on the form without another program?

I didn't say that, it can be done and depending on your form design you can use the resize event.

for example if you have a control called myControl in the bottom right of the form in the form resize event you could put the following:

on error resume next 'in case mycontrol.width>insidewidth
mycontrol.left=insidewidth-mycontrol.width
mycontrol.top=insideheight-mycontrol.height

One I often use for continuous subforms at the bottom of the main form is

on error resume next
mysubform.height=insideheight-mysubform.top

but as I said, it depends on the design of your form and whether this is practical

 

[CJ_London]

Here are some other links

http://www.599cd.com/tips/access/misc/AC310-resize-form-vba.asp
http://www.youtube.com/watch?v=TC1QjUyOXi8
http://www.utteraccess.com/forum/Auto-resize-form-based-t1946988.html

If you are using access 2007 or later, you can use anchoring - see this link - search for access 2007 anchoring

http://office.microsoft.com/en-gb/a...or-move-as-you-resize-a-form-HA010253986.aspx

I think the resizer Linq is referring to is:
http://www.jamiessoftware.tk/resizeform/rf_jump.html

 

[DeanEdwards2012]

OK, thanks a lot for your help guys, i'll have a go and see what happens. its for the company i work for so if i cant manage it with code, they'll just have to buy the liscences.

Thanks again