Listing info on a report

[Guest]

I have a report lising case information. I am listing the case#, SS#,
finding, Element#'s (which are: 10, 11, 12, 13, 14) for each case. I have
findings of Correct, Discrepancy, Error and Drop. What I want to do is, that
if the case is Correct, I don't want to list the Element#'s just the Case
Number, SS#, and Finding.
How can I go about this. Thanks

 

[Marshall Barton]

I have a report lising case information. I am listing the case#, SS#,
finding, Element#'s (which are: 10, 11, 12, 13, 14) for each case. I have
findings of Correct, Discrepancy, Error and Drop. What I want to do is, that
if the case is Correct, I don't want to list the Element#'s just the Case
Number, SS#, and Finding.

Use VBA code in the (detail?) section to make the Element
invisible:

Me.txtElement.Visible = (Me.txtCase <> "Correct")