Adjust controls to screen in ms access vba

Just Upgraded to a gaming monitor with a resolution of 2500X1080 and are having a problem resizing boxes on the form to fit when the form is maximize i got a insideheight of 16200 and insidewidth 38400 i am looking for a vba function that will resize the box to the height and width of the screen regardless of resolution.
thanks
SvgmassiveAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What version of Access are you using? The newer versions come with Anchoring and such which can help you to resize.

If you want full control, you should look into Shrinker-Stretcher: http://www.peterssoftware.com/ss.htm
0
 
Martin LissOlder than dirtCommented:
Here is an Experts Exchange article that may help you.
0
 
Martin LissOlder than dirtCommented:
And here is my article. It says it is for VB6 but it may also work for you.
0
 
SvgmassiveAuthor Commented:
I am still having the problem resizing the label across the form,i believe the value of 38400 the insidewidth is too high.is there a way to convert it
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Convert it to what? If it's too high, then reduce it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.