Hiding a subreport

  • Thread starter John Spencer (MVP)
  • Start date
J

John Spencer (MVP)

Check the HasData property of the subreport's report control.

If Reports![rpt Employee Info_SS]![rpt Employee Info Sub].Report.HasData then
...
Else
...
End If
 
S

Scott

i'm tring hide/show a label on report if a subreport returns no records. i'm
doing in the on format event of the detail section.

i tried saying

If Reports![rpt Employee Info_SS]![rpt Employee Info Sub].Report!wageYear
Is Null Then


Report![rpt Employee Info_SS]![rpt Employee Info Sub]!Visible =
False

Access gave error on 1st line. How can i check the recordset count of a
subform?
 

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

Access Report Coding 0
OutputTo 3
Show phrase when no data for a report 3
SynNeed to account for null values in subreports 2
Code to run report creating by Crystal Report 9 0
HasData Property 3
Repost:Use runcommand acCmdPrint to print a report 2
data appears in Layout View but not in Print Preview? 1

Top