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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.