Subreport won't shrink

Dear experts -
This is driving me crazy!
I have a report and a subreport.
I set the source of the subreport in the open event - that works just fine.
The problem is the subreport will not shrink when there are no records!
The section detail is set to 'can shrink'.
I have even gone into the subreport and removed ALL fields - leaving a 1/4 inch detail height but also setting detail to "can shrink" in the subreport. The recordsource of the subreport is set to return no values (just so there is not some hidden value popping up - for testing purposes).
Finally, there are NO overlapping fields in the detail section.
Any ideas?
Thanks -
terpsichoreAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PatHartmanConnect With a Mentor Commented:
I don't think there is a way around it.  Report view doesn't run your event code and you would need to use event code to "hide" the subreport.

Do you have to use ReportView?
0
 
hnasrCommented:
Upload a sample database, with just the reports and their record sources, showing the issue.
0
 
terpsichoreAuthor Commented:
it is rather complex - i was hoping to get a few ideas to try first...
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
terpsichoreAuthor Commented:
I SEE THE PROBLEM - it shrinks in Print Preview but not in Report View - is there a way around this?
0
 
hnasrCommented:
"it is rather complex -"
Why complicate it?
Reproduce the problem. This means a simple report with 2 tables, 3 or 4 fields each.
Then explain what to do to see the issue.
0
 
terpsichoreAuthor Commented:
I guess not - we like to have the luxury of having users click on report elements and calling up other forms, etc. But I guess there is no solution to this issue. Thank you.
0
 
PatHartmanCommented:
I too like the ability to use report events to drill down but there are quirks with the "feature" so I only use it in limited cases.  

Send a complaint to MS.  They tell me they listen and in this case, the ReportView should work the same way as the PrintPreview and not show empty subreports.  If people don't formally complain, the Access team has no way of knowing what causes us problems.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.