473,703 Members | 2,644 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Shrinking/Stretching Forms

4 New Member
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 8278
3,653 Recognized Expert Moderator Specialist

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
4 New Member
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 Recognized Expert Moderator Specialist
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 Recognized Expert Top Contributor
I personally use "ShrinkerStretc her" 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
4 New Member

I have no doubt that ShrinkerStreche r works perfectly but you also have to pay for it. Where's tha fun in that?
Apr 23 '18 #6
1,430 Recognized Expert Top Contributor
No fun. Really depends on what your time is worth. I recon if you could re-invent ShrinkerStetche r 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
4 New Member
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
460 Recognized Expert Moderator Contributor
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...it s completely free!

Hope that helps
Nov 20 '21 #9

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

Similar topics

by: willie | last post by:
Hi all: I restored one backup database (7.9 GB mdf) on two diffrent servers. I shrunk them by clicking "Move pages to beginning of file before shrinking". After shrinking, one mdf file is 6.7 GB, and the other is 4.2GB. I shunk again and again: 1. the 6.7GB become 5.9GB, 5.2GB, 4.7GB and 4.2Gb (four times) 2. the 4.2Gb become 4.0GB (just one more time)
by: Ron Holmes | last post by:
I want to place a background image on a windows form. Is there a way to prevent the image from Tiling without using an image box resized to the size of the form? I am using Visual Studio 2003 .NET. This is an easy thing to do in VB6.
by: Jens | last post by:
I have a database file LEAR_Index(yes, it hold index data) from a have have recently removed a bunch of data. It is about 120 Gb, 100Gb of which is not used. I wan´t to shrink the file to lean 30-40Gb. I´ve been trying this: dbcc shrinkfile('LEAR_Index',40000) But to no apparent avail; the file did not shrink.
by: jeffreyv | last post by:
Hi! I'm studying to have my MCSE 70-228 certification and I'm trying some things with backing up transaction logs and shrinking it. Here's what I do: There is no activity in the database by the way. I have a transaction log of 1792 kb...
by: John Baker | last post by:
Hi: I have a report that contains a remarks field which is a "memo" format field. I have that field on a single line in the report, and have it given a property of "Can Shrink", in the hope that he line will vanish when there is no data entered in the memo field. Its not shrinking! There is nothing else on the line, and no field name or anything else. I have tried shrinking it to a single small line and saying "Can Grow", but its growing...
by: phknox | last post by:
Due to a HD crash, I had to reinstall VS.net 2002. Now when I build my c# project, the controls on my windows form shrink. Each time I build, the controls shrink. I can resize them, but they still shrink. Anyone have a suggestion as to what the problem is? Thanks, phknox
by: Raed Sawalha | last post by:
I read in MSDN an examples for Image Stretching but something I can not understand is this line e.Graphics.DrawImage(newImage, destRect1, x, y, width, height, units); what is e in all example they did not show what is e ????? any help
by: Keith | last post by:
I have just tried form inheritance for the first time and I am having trouble with the controls shrinking each I build the project on my home computer and growing each time I build on my work computer. I had found that the AutoScaleBaseSize setting was inconsistent on some of the inherited forms and changing that stabilized the forms at home. But at work all the control widths are growing 28% on each build and all the control heights...
by: michael | last post by:
I am working on a form in which I have divided onto 5 separate pages ( hopefully for ease of completing ) which employ various field types such as radio buttons, text and memo fields, a check box or two and file upload fields. a self-imposed constraint was to reduce the number of clicks, so I turned to javascript to automate the process of moving from one page to another, and would like to ensure this works in both ie and firefox. ...
by: Harry_Crow | last post by:
I wanted to change the Non client area height. This was not possible in the existing Form TitleBar. So I set the FormBorderStyle= None and I calculated and introduced the Non Client area myself. So the height and width of the Non Client area is 15 and 4 pixels border respectively. Also the Nonclient area has been painted as per our need. Now all is fine but in design time when the controls in the form are anchored other than top, left. Now...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.