Formatting a row to Visible = False when certain conditions are me

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

Guest

Is there a way to set an entire row of fields (record) to Visible = False or
fill the fields with color?

For example:
I have a sales report with the Managers info at the top of the report and
all regular sales people listed under him with a total line at the bottom.
The problem is we don't want the managers sales visible but we need them
included in the totals. So is there a way to set a filter for what I want to
do? Conditional formatting only works on one field at a time and you cannot
format all the fields based on the infor of one field. I sure hope there's a
way to do this.

Thanks,
Chris
 
You can add code to the On Format event of the detail section like
Cancel = (Me.txtSomeField = "Some Value")
 
Back
Top