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!