Yes/No field

S

sharon

I have a yes/no field that if marked Yes will mean that the company is still
acitve. How do create an expression to show that if it is Yes then the
"company field" background will change to a color let's say yellow. When a
report is ran then those companies that are active will be highlighted in
yellow.
 
D

DavisGail

Sharon,
Go to the design of your report. Click on the company field; right click
and choose conditional formatting. Under Condition 1, Pull to to "Expression
is" and in the next block type [Name of YES/NO field] = -1
You can then choose the formatting options to fill the block or change the
color of text to yellow.
 

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

Help with a query 2
Explain a yes/no check 2
How do I automatically populate a field in Access? 8
Access Table Yes / No Field Question 4
IIF expressions 2
Yes/No field in Query 1
Editing fields based on Yes/No field 6
If yes enter zero if no enter result 9

Top