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
ASKER
No I need the main form holding the subform. That solution will not work for me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Looks like Dale and I have the same experience..... NICE!
ASKER
Thank you sincerely for the helpful replies.
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.