Link to home
Start Free TrialLog in
Avatar of Sue Tippett
Sue TippettFlag for United States of America

asked on

Close gap between sub forms on a main form

I have two forms that a embedded in a main form detail section.
Sub Form 1 has budget rows.  Usually just one row can be a many as three
Sub Form 2 has transaction.  Many rows

The issue I am have is I am unable to close the gap between the sub forms when displayed (See Attached file)
Sub Form 1 has not header or footer.
Sub Form 2 has a footer for totals.

I have set the property Can Shrink to true on Sub Form 1, it still take up more space then it should.
I move sub form 1 to the header of the main form, didn't make a difference.
Any suggests would be greatly appreciated.

Access 2010
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

>>Sub Form 2 has a footer for totals.

if necessary you can also put the totals in your main form instead.
Retry sending attached file.
You will get a quick answer if you upload a reproduced database demonstrating the issue.
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sue Tippett

ASKER

I made sure the controls were close, they are stacked.  I will try some of the suggestions you sent.  Thank you
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome ~ happy to help