How can I conditionaly suppress my report header?

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?
 
M

Marshall Barton

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)
 
Top