473,386 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Resize a form depending on displayed fields

Good Morning,

I am trying to find out if there is anyway I can get the form to resize depending on the amount of data displayed?

Basically to try and explain a little I have a continuous forms that will display between 2 and 12 records in a table, the controls are set on the header and footer and I need to see if there is a way that the entire form will grow to accomidate the 12 rows or shrink when there are only 2.

I am using Access 2003

Thanks

Eb
Nov 20 '08 #1
2 1571
well if you like set the record source of your form with the name of your table.. by this the form automatically change it size base on the number of row in the record.
Nov 20 '08 #2
Thanks for your reply,

The form is set to a query as it shows results that are filtered depending on what is selected in a combo box,

The form opens up the same size regardless of how many rows are returned, is there any way to adjust it in the code perhaps of the after update event of the combo?
Nov 20 '08 #3

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

Similar topics

5
by: Raffi | last post by:
Hi folks, I'm new to JavaScript and need some help. I have a form with a select field. Depending on what is selected in this field, I want to display or not display another select field. For...
3
by: Steve | last post by:
Form FrmRestock's recordsource is QryFrmRestock. The TransactionDate field's criteria is set ats: Forms!FrmRestock!LastXDays. LastXDays on the form is a combobox where the selections are 30, 60...
4
by: John Buchmann | last post by:
I thought this would not be difficult, but i'm stumped! I need to iterate through a bunch of form fields, and read the data (value, text, etc.) from them. (I need to iterate through them...
8
by: touf | last post by:
Hi, I've developped an application on a machine that have 1280,1024 , the forms look ok, WhenI change the resolution to 1024,768 the forms are biggest than the screen. Is there a way to resize...
1
by: Rich | last post by:
Hello, I have a child form in a parent MDI form. The childform is being shrunk and cannot be resized when screen resolution is 800x600. The end user who uses my app cannot see stuff on the...
1
by: Bob Alston | last post by:
I have a system where many subforms are used. Often the size of the subform had to be larger than could be displayed without scrolling. I set the height of the subform to the typical height...
2
by: dynamictiger | last post by:
I am building a wizard and have an issue with one sub form. Whilst all others are about 5 fields tall this one is 15 fields. My choices are either to resize the parent form ridiculously large for...
1
by: joedalton101 | last post by:
Is there some piece of code that will make subforms resize automatically according to the amount of records displayed? For example my main form just contains artist names. Subform1 contains...
3
by: jkwok | last post by:
Hi, I have a form with two rich text boxes and two buttons. Some of the users want to be able to maximize and/or resize the form and have the rich text boxes resize to fit and the buttons always...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
Oralloy
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 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.