Solved

Hide Subreport if no records

Posted on 2016-08-28
7
22 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

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.

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…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

744 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

13 Experts available now in Live!

Get 1:1 Help Now