Text Box to Appear Only if Subreport Displays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my unbound text box to display "Revision" only if one or both of these
subreports display:
srptProfilesRevisions
srptProfilesRevisionsProfiles.

How can I code the text box to do this?

Thanks!!!
 
Hi John

What causes the subreports to display or not display? Is it dependent on
whether they have any data?

If so, then you probably have code similar to this in your Detail_Format
event procedure:

srptProfilesRevision.Visible = srptProfilesRevision.Report.HasData
srptProfilesRevisionProfiles.Visible =
srptProfilesRevisionProfiles.Report.HasData

Just add some code then to test if either subreport is visible:

If srptProfilesRevision.Visible Or srptProfilesRevisionProfiles.Visible Then
' do whatever
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report asks for Parameter and Won't Display Subreport 7
Reports/SubReports 2
I want subreports to display in even if they have no associated da 3
adjusting the height of text boxes in a report 1
Access How to prevent subReport from breaking across pages? 1
Total Costs in Text Box. I get error if values are missing... -- 1
Strange report/subreport problem 4
Referencing a subform control on a subreport 1

Back
Top