Determine scaling in Microsoft Access

[ej256]

So I'm running into an issue with Windows 10 users in my database. For a lot of users, the default scaling (or zoom) is set to 125% or 150% since they have a high resolution monitor. I have no issues handling different resolutions as I know a function to determine it, but I cannot find a way to determine what users have their their scaling set at. Due to this, my forms are missized and many are too large and do not fit on the screen. Is there a way in vba to determine the scaling that a user has?

 

[CJ_London]

there is not much out there in terms of code you can adapt. I've had a quick look round and found this as a starting point

https://msdn.microsoft.com/en-us/library/windows/desktop/dn280511(v=vs.85).aspx

looks like you need to get the value for MDT_EFFECTIVE_DPI

 

[ej256]

Solution found here. CJ_London appreciate you pointing me in the right direction, as I wasn't sure what I was searching for.

https://www.pcreview.co.uk/threads/how-to-determine-the-dpi-setting-for-current-user.2521177/

 

[CJ_London]

Are you sure that gives you what you want? I thought you wanted to get the zoom factor.

It returns the same value, regardless of the zoom

 

[CJ_London]

my mistake - only if multiple monitors

 

[ej256]

my mistake - only if multiple monitors

Yeah, the only issue I've been having is when people are working on their laptops. When they have their laptops docked, there hasn't been an issue.

 

[CJ_London]

if you open forms maximised, then it all shows on the screen - but if the form is bigger than the screen you will need some code in the resize event to move/resize controls into a better position. Or if using 2007+ try using the layouts and anchoring

Usually better to design the form to suit the smallest screen.

Good luck!