Conditional Formatting and When?

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a report that prints transactions grouped on a visit number. I
can calculate the amount owed per visit, but would like to suppress the
visites where the amont is 0. I have tried setting the Detail Visible
property to False, but I get one visit, and then everything else is
suppressed. Is there a way to control this better? I have tried to put
it in the footer section (assuming one could work "backwards") but that
is not working. I don't <think> the header section would work, as the
sum function (I think) depends on the transaction details...

Thanks for any help.

Steve
 
If I understand correctly, you can add code to the On Format event of the
report like:
Cancel = (Me.Amount = 0)
 
Back
Top