471,897 Members | 1,793 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

Shrinking/Stretching Forms

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
8 7903
3,653 Expert Mod 2GB

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
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.
Apr 23 '18 #3
3,653 Expert Mod 2GB
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
1,430 Expert 1GB
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

Apr 23 '18 #5

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
1,430 Expert 1GB
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!!!

Apr 23 '18 #7
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
405 Expert Mod 256MB
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
Nov 20 '21 #9

Post your reply

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

Similar topics

6 posts views Thread by Jens | last post: by
2 posts views Thread by phknox | last post: by
3 posts views Thread by Raed Sawalha | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.