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!

Apr 23 '18 #1

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!

Apr 23 '18 #2

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!

Apr 23 '18 #3

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.

Apr 23 '18 #4

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

Apr 23 '18 #5

tridza

Phil,

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

Apr 23 '18 #6

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

Apr 23 '18 #7

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!

Apr 24 '18 #8