Hide subreport if it has no data

Catalina · Jul 9, 2011

In Access 2010 I'm trying to hide a sub report in the Detail section if it has no data.

I found some possible solutions in this forum as well as on other sites.
Tried them all, and none of them work for me. The sub stays visible no matter what I do.
The set shrink to yes doesn't do anything either.

Any suggestions how to accomplish this?

Thanks.

Catalina · Jul 11, 2011

Somehow I got it to work.
If I remembered what I did to make it work I would have posted it here.

321jimk · Jul 15, 2011

that's soo wrong!!

GinaWhipp · Jul 15, 2011

Well, this works...

Code:

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
On Error Resume Next
If Me.srpPOSpecialNotes.Report.HasData Then
Me.lblSpecialNote.Visible = True
Else
Me.lblSpecialNote.Visible = False
End If
End Sub

You can use variations to make subreports, text boxes, etc... visible or not.

Catalina · Jul 16, 2011

Thanks Gina, I'll keep that code handy.

Catalina

GinaWhipp · Jul 16, 2011

You're welcome!

HIMANSHU · Sep 11, 2013

I want that if the sub report has no data then it should not be displayed and at the same time the blank space which is generated by it should also be removed...

I am able to remove the subreport with no data with the above code but the blank space still persists...

Pls Help

GinaWhipp · Sep 11, 2013

HIMANSHU,

In the Section that contains the Subreport set the Can Shrink proprty to *Yes*.

Side Note: It's always better to start your own thread then attach your question to another thread. You have a better chance of getting answers that way!

HIMANSHU · Sep 11, 2013

Point taken Gina...thanks...started a new thread...

Hide subreport if it has no data

Catalina

Registered User.

Catalina

Registered User.

321jimk

Registered User.

GinaWhipp

AWF VIP

Catalina

Registered User.

GinaWhipp

AWF VIP

HIMANSHU

Registered User.

GinaWhipp

AWF VIP

HIMANSHU

Registered User.

Similar threads

Users who are viewing this thread