I have a pretty basic report in an Access db. The only thing I want to change is the following:

I have a TextBox that displays a code 'Active' or 'Inactive' that always prints. The report prints every record that it should, but I would like to suppress printing for the TextBox only if it contains the value 'Active'

In other words, I want all records to print in report, but I only want the TextBox to display a value if it equals 'Inactive'.

It has nothing to do with record selection, just want to clean up the Detail area by showing a message when it is 'Inactive'

Does that make sense, if so how do I do it? Thanks in advance.