Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Database Container _ Resize Database At Different Resolution

Posted by: raphael99 Dec 8 2017, 02:48 PM

My wife has a screen resolution 1440x900.
My database wrote for her need a resolution of 1680x1050.
Is there anything I can do for run fine the database?
Thanks to all

Posted by: theDBguy Dec 8 2017, 02:52 PM

The "best" approach is to design your form using the lowest resolution where it will be used. It is easier for a form to expand in size than to contract.

Just my 2 cents...

Posted by: ADezii Dec 8 2017, 03:02 PM

If you designed the DB at a Resolution of 1680x1050, you can use this as a 'Base Resolution' and Resize all Controls on another PC based on that PC's Resolution. The down side is that this would involve multiple API Calls and the Coding would be rather complex. I'll see if I can find an appropriate Link and return here with it.

Refer to Post# 5 in the following Thread:

Posted by: raphael99 Dec 8 2017, 06:07 PM

mmmh.. so I have to re-build the finished database? No escapes?

Posted by: theDBguy Dec 8 2017, 08:46 PM

Well, you could try the link ADezii posted earlier.

Good luck!

Posted by: raphael99 Dec 9 2017, 05:09 AM

It seems it works great. But there is a point. The background image I incorporated doe not fit the application size. I shrinked but not avail. I maximized but not avail. I tried also to custom size for application itself-
Is there something I'm missing?

Posted by: theDBguy Dec 9 2017, 12:55 PM


Did you try to set the Picture Size Mode to Stretch?

Posted by: raphael99 Dec 9 2017, 02:29 PM

I tried all the possibilities. Ending to set the preferred resolution screen and start to write down the forms.
It is a pity because the method suggested was very interesting.
Anyway thnaks to all notworthy.gif

Posted by: theDBguy Dec 9 2017, 03:26 PM


You're welcome. Sorry we couldn't solve your problem. However, as I said earlier, it is so much easier for Access Forms to resize to a bigger than a smaller size. So, once you are done downsizing your form, you can still use the technique you learned to resize the application to higher resolutions.

Good luck with your project.

Posted by: ADezii Dec 10 2017, 11:58 AM

The background image I incorporated does not fit the application size.

Just out of curiosity, does this 'background image' exist as an Embedded Graphic as defined by the Form's Picture Property? If so, it seems odd that the Picture Size Mode adjustment suggested by theDBguy would not work.

Posted by: raphael99 Dec 10 2017, 01:24 PM

Yes it is embedded. I don't have Stretch option. I only have a similar command I think it is the same "Zoom". Anyway (my access is in italian) I have tried all the options in size imagine. If you post a screenshot of your access size imagine maybe I'm able to have mistaken command.
Otherwise with Zoom the result it is the same

The resutl anyway with your code is very impressive

Posted by: theDBguy Dec 10 2017, 03:59 PM


Check out the below image:

The Picture Size Mode defaults to "Clip." Click on the dropdown arrow and select "Stretch."

Are you saying you don't see the same thing as the above image? If so, can you please post an image from your Form? Thanks.

Posted by: raphael99 Dec 11 2017, 12:57 AM

For me Stretch is "Ridimensiona" As I tried:

And the effect is the follow:

Sorry for not to be able to post as DBGuy is...