Shrinking/Stretching Forms

[tridza]

This thread as been split from an earlier thread (i want forms to auto adjust based on resolution of user) as it is not acceptable to ask new questions within existing threads.
-NeoPa (Admin).

Hi guys! i know this is an old thread but I find it very useful.
I've used the code from Access Developers Handbook and it works perfectly when I apply it to a single form. However, when I try to resize the same form in my navigation form the code is not working.
I would really appreciate if you could help me on this as I'm beginning to be very frustrated.
Thanks in advance!

[twinnyfo]

tridza,

Welcome to Bytes!

I am not sure the code for resizing forms will work "as is" on Navigation Forms. This has to do with how objects are referenced within Navigation Forms. This is another reason I try to avoid Navigation Forms. I think they cause more problems than they solve.

Hope this hepps!

[tridza]

Hi twinnyfo!

Thanks for the reply! I know the code isn't perfect but its the best I've tested so far. My guess is that the code doesn't respond because form that is resizing resides on a subform, navigation subform to be precise, so the code needs a minor adjustment to catch the navigation subform. If you have any ideas how to make it work please share.
Thanks!

[twinnyfo]

If you use the attached DB in Post #5, this will handle Sub-Forms. However, I do not think it iwll handle Navigation Forms. These forms have a different manner of referencing Objects, which can confuse matters--even if you are not resizing the controls on a form.

However, again, this makes me even more hesitant to use Navigation Forms. Just execute each form as needed and use some form of switchboard or dashboard that directs the user to the appropriate functions within the DB.

[PhilOfWalton]

I personally use "ShrinkerStretcher" from Peter's Software. Basically it allows a form to be any size you choose, either by maximizing the form, or dragging the corners and edges of a restored form. All the controls are stretched or shrunk to match the size of the form.

Although it doesn't show properly on this Website, the first image is full screen, and the second image about half screen

Phil

[tridza]

Phil,

I have no doubt that ShrinkerStrecher works perfectly but you also have to pay for it. Where's tha fun in that?

[PhilOfWalton]

No fun. Really depends on what your time is worth. I recon if you could re-invent ShrinkerStetcher in under 300 hours you would be doing well. I don't know what your time is worth, but as I have been retired for 25 years, my time is worth nothing.

You're absolutely right... it is expensive!!!

Phil

[tridza]

Phil, you're right. I have a feeling that I'm close. The Access Developers Handbook code is working but not on navigation subform. It only needs a minor adjustment and I can't really get into the code that deep to understand what's happening. I'm sure that someone with a bit more knowledge than me would know how to do it.Anyway, thanks for replying!

[isladogs]

I've only just chanced upon this thread which I realise is over 3 years old
For info, I have automatic form resizing (AFR) code that works on all types of forms & subforms.

See my You Tube video presentation to an Access User Group session in Sept 2021: Automatic Form Resizing in Access and my extended tutorial at Automatic Form Resizing Tutorial.

Since the video was recorded & that article was last updated, I have added further functionality including support for datasheets, split forms & navigation forms. The latest version of my example app can be downloaded from https://isladogs.co.uk/dl/afr/afr.zip

Also worth mentioning...its completely free!

Hope that helps