By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,558 Members | 2,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,558 IT Pros & Developers. It's quick & easy.

Resize a form depending on displayed fields

P: 26
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


Nov 20 '08 #1
Share this Question
Share on Google+
2 Replies

P: 25
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

P: 26
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

Post your reply

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