How can I conditionaly suppress my report header?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

If the record count for my report is a certain value, I want to supress the
report header and display only the detail section.

What object and property do I need to set to supress the report header?
 
Dave said:
If the record count for my report is a certain value, I want to supress the
report header and display only the detail section.

What object and property do I need to set to supress the report header?
Click to expand...


Add an invisible(?) text box named txtRcordCount to the
report header and set its expression to =Count(*).

Then you can use code in the header section's Format event
procedure:

Me.Section(1).Visible = (txtRcordCount <> certainvalue)
 

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

Suppress a section if the subtotals equals zero 1
Suppress Report Header 4
header question for report footer 4
Suppress Data if Sum = 0 2
How can I supress a section header if the value returned for the header is empty? 1
report footer 2
Replace Report page headers with Sub Report headers 3
Hide a section based on contents at run-time 10

Back
Top