Conditonal Statements in Report

[Clay]

I am new to access and need some assistance. I have 2 variables in a table
that I want to include on a report. The first one is a yes or no answer and
the second is a open text rsponse stored in the table. Essentially what I
want to do is in the report if an answer is no then I want to print out the
comment of the text response. There are multiple questions and each text
response is different. Is this possible?

 

[Damon Heron]

In design view, right click on the text response field, and select
conditional formatting. Select "Expression is" then in the textfield, put
[your Y/N fieldname]= Yes. Then select text color as white. When the
condition is true (field = yes) then your text response will be invisible.

Damon