Form Resizer - Continuous Form

ARW17

Board Regular
Joined
Oct 31, 2016
Messages
109
Users have different size and shaped monitors and I'm trying to see if there's a way to resize my continuous form automatically to fill their screen efficiently. I found this:
which seems great, but doesn't address continuous forms. Can this be done or is there a rule of thumb for fitting "most" users?

Right now if I minimize the Access window, part of the form is hidden and I'd like it to just shrink instead. I've checked into the can grow/can shrink formats, but that doesn't seem to be what I'm looking for.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
poke around here Mendip Data Systems
or contact Colin. I've seen many posts in other forums about his code to resize everything based on user monitor resolution - at least that's what I think you're asking. As far as I know, that code is free but don't quote me on that. I poked around but couldn't find it there; not sure what it would be listed under.
 
Upvote 0
Solution

Forum statistics

Threads
1,214,970
Messages
6,122,514
Members
449,088
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top