Solved

Subreport won't shrink

Posted on 2013-11-21
7
537 Views
Last Modified: 2013-11-22
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 -
0
Comment
Question by:terpsichore
  • 3
  • 2
  • 2
7 Comments
 
LVL 30

Expert Comment

by:hnasr
Comment Utility
Upload a sample database, with just the reports and their record sources, showing the issue.
0
 

Author Comment

by:terpsichore
Comment Utility
it is rather complex - i was hoping to get a few ideas to try first...
0
 

Author Comment

by:terpsichore
Comment Utility
I SEE THE PROBLEM - it shrinks in Print Preview but not in Report View - is there a way around this?
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 30

Expert Comment

by:hnasr
Comment Utility
"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
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:terpsichore
Comment Utility
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
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now