Solved

Hide Subreport if no records

Posted on 2016-08-28
7
27 Views
Last Modified: 2016-08-28
Experts, I am trying to hide a subreport if there are no records.   Not sure if this is with Dcount or using a txtCounter. The table is tblRepayments and the parent and sub are linked on tblDraws.ID and tblDraws_Details1.DrawIDRpmt.

thank you.
0
Comment
Question by:pdvsa
  • 4
  • 3
7 Comments
 
LVL 19
ID: 41773697
try setting the Can Shrink property of the subreport control to Yes (True) -- near the bottom of the Format tab of the Property Sheet (Alt-Enter if it is not showing)
0
 

Author Comment

by:pdvsa
ID: 41773703
Hi, I actually did try that and it doesnt seem to hide it.
0
 
LVL 19
ID: 41773708
this will work in Print Preview but not Report View -- assuming subreport is in the detail section (if not, change accordingly:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
'160828 s4p
   With me.controlname_Subreport
      .Visible = .Report.HasData
   End With
End Sub

Open in new window

0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:pdvsa
ID: 41773744
hmmm that did seem to turn it off in print preview like you said but I dont use print preview much at all and am more interested in turning if off in Report View.  Let me know if you think of something.  I did have code for this but I have lost the db.  thank you for the help...
0
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41773751
Report View doesn't run code

you might try setting controls heights on subreport to something very small like 0.1 -- and subreport control very small too -- and CanGrow to Yes. you will still get 1 row but it won't be as tall. Make sure no borders around any controls or subreport control so all that will happen is just a little more space.
0
 

Author Closing Comment

by:pdvsa
ID: 41773784
Ok thank you.
0
 
LVL 19
ID: 41773802
you're welcome ~ happy to help
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

776 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