Conditonal Statements in Report

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

Guest

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?
 
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
 
Back
Top