Sue Tippett
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
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
Retry sending attached file.
You will get a quick answer if you upload a reproduced database demonstrating the issue.
You will get a quick answer if you upload a reproduced database demonstrating the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I made sure the controls were close, they are stacked. I will try some of the suggestions you sent. Thank you
you're welcome ~ happy to help
if necessary you can also put the totals in your main form instead.