[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

Hide Subreport if no records

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
pdvsa
Asked:
pdvsa
  • 4
  • 3
1 Solution
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
pdvsaAuthor Commented:
Hi, I actually did try that and it doesnt seem to hide it.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pdvsaAuthor Commented:
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
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
 
pdvsaAuthor Commented:
Ok thank you.
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now