By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Auto resize to fit screen

P: 11
I'VE done followed some thread on auto resizing a access form to fit current screen in vba for access forms but have no luck. I want the form to automatically resize to fit current screen. I dint know where to where to start, appreciate if any help.
Jun 18 '18 #1

✓ answered by twinnyfo

Adict,

Bytes has a good thread on this: Resizing Forms. Please download the DB from Post #5. If I remember correctly, it resizes all your objects and subforms. In my experience with it, it works fine to take a form andresize it once to fit the screen. However, if you open a form, resize it, resize it again, return it to normal, and resize it again, each time you do that (with the form constantly open), many of the propertions get wonky. However, it's a good bit of code to work with.

Let me know if it hepps!

Share this Question
Share on Google+
4 Replies


PhilOfWalton
Expert 100+
P: 1,430
I use a program called ShrinkerStretcher from Peter's Software
http://www.peterssoftware.com/ss.htm

Works very well and would be very hard to code starting from scratch.

Phil
Jun 19 '18 #2

twinnyfo
Expert Mod 2.5K+
P: 3,127
Adict,

Bytes has a good thread on this: Resizing Forms. Please download the DB from Post #5. If I remember correctly, it resizes all your objects and subforms. In my experience with it, it works fine to take a form andresize it once to fit the screen. However, if you open a form, resize it, resize it again, return it to normal, and resize it again, each time you do that (with the form constantly open), many of the propertions get wonky. However, it's a good bit of code to work with.

Let me know if it hepps!
Jun 19 '18 #3

P: 11
Twinnyfo - thank you very much. your codes just worked perfect on what i was trying to do. Just love your work

Regards
Jun 20 '18 #4

twinnyfo
Expert Mod 2.5K+
P: 3,127
Glad I could be of some hepp. The code and that DB is not mine, though. I’ve seen several places that have identical or similarly functioning code.

Happy coding!
Jun 20 '18 #5

Post your reply

Sign in to post your reply or Sign up for a free account.