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!
8  8252 
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!
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!
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.
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
Phil,
I have no doubt that ShrinkerStrecher works perfectly but you also have to pay for it. Where's tha fun in that?
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
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!
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
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
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...
|
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,...
| |
