Avatar of stephenlecomptejr
stephenlecomptejr
Flag for United States of America asked on

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
Microsoft AccessVBA

Avatar of undefined
Last Comment
stephenlecomptejr

8/22/2022 - Mon
Fabrice Lambert

From what I understand, you have a main form (non continuous) holding a data grid subform.

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.
stephenlecomptejr

ASKER
No I need the main form holding the subform.  That solution will not work for me.
ASKER CERTIFIED SOLUTION
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mark Edwards

Looks like Dale and I have the same experience.....  NICE!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
stephenlecomptejr

ASKER
Thank you sincerely for the helpful replies.