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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statement on Report? 1
Converting GPS coordinates to decimal in Report 0
Report to display SQL code 2
Bilingual report 4
Hidding blank fields in reports 2
Assigning print date / batch number to reports & invoices 6
Access 2007,reports,VBA 2
Pull report values in VBA 1

Back
Top