How to make Microsoft Access subform adjust it's height and bring footer info closer to last record?
How to make Microsoft Access subform adjust it's height and bring footer info closer to last record?
Please note the following pics - that shows a timesheet where one sample image shows only two records and another shows multiple records where you have to scroll vertically.
I want to adjust the height of the subform so that the footer info always shows directly below the last record:
Now I can manually do this by grabbing the height of the subform if there is only one record, two record, etc... but that would be a lot of work. And look at the total number of records then adjust the subform accordingly but is there not an easier way?
Thank you in advance for pointing me in the right direction!
ee-sample1.PNG
ee-sample2.PNG
Please note the following pics - that shows a timesheet where one sample image shows only two records and another shows multiple records where you have to scroll vertically.
I want to adjust the height of the subform so that the footer info always shows directly below the last record:
Now I can manually do this by grabbing the height of the subform if there is only one record, two record, etc... but that would be a lot of work. And look at the total number of records then adjust the subform accordingly but is there not an easier way?
Thank you in advance for pointing me in the right direction!
ee-sample1.PNG
ee-sample2.PNG
Last Comment
ASKER
No I need the main form holding the subform. That solution will not work for me.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Looks like Dale and I have the same experience..... NICE!
ASKER
Thank you sincerely for the helpful replies.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
I suggest you get rid of the subform, make the main form continuous, put the column's name in the form's header, and the buttons in the form's footer.