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

Auto-Resize subform based on number of records

100+
P: 166
Happy Hump Day!

I was wondering if it would be possible to some how resize my subform
based on the number of records it holds. I have a subform that I
populate via a non-updatable query. It just shows the user what he/she
has ordered. Based on this information, I would like for the user to
just be able to view the information with out having to scroll. can
this be done?

Thanks
Dec 10 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,287
You would need get the number of records to be displayed, multiply by a height for each record, and then set the subform.Height accordingly. You will have to experiment with that height property because it isn't in inches, use ~200 or something.
Dec 10 '08 #2

100+
P: 166
Hi Chip,

I'll try that and see what happens

Thanks
Dec 10 '08 #3

Post your reply

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