Conditional Format Column 2

[access2010]

Could I please receive a suggestion on how to Conditional Format the field = Trd_Action =

If the field = Explanation = Contains the word = Closed = the back ground colour would be = Green

If the field = Explanation = Contains the word = Open = the back ground colour would be = Pink

Your assistance will be appreciated.

Nicole

 

[CJ_London]

use the instr function as conditional formatting of your trd_action control

expression is.................instr([explanation],"closed")>0

or you can try like

expression is.................[explanation] like "*closed*"

 

[arnelgp]

same thing here, but uses the combos 2nd column.

 

[access2010]

same thing here, but uses the combos 2nd column.

Thank you CJ_London and arnelgp for your suggestion, but how do I use the Second Column, could you please offer me a suggestion using the attached database?
Thank you.

Nicole

 

[arnelgp]

on design view of your form, click on Trd_Action textbox.
on access ribbon->Format->Conditional format (see the CF i made).

 

[access2010]

on design view of your form, click on Trd_Action textbox.
on access ribbon->Format->Conditional format (see the CF i made).

 

[access2010]

Thank you for your note, arnelgp, can you please advise me where to find your = CF = file?

Crystal

 

[arnelgp]

CF (Conditional Format).

 

[access2010]

Thank you, arnelgp for your CF (Conditional Formating) link, but it does not have any reference that I can find for using a second column to change the CF back ground colour.
If you can point me to this condition as shown in our attached database, we would appreciate it.
Column one is visible
Column two is the conditional colour control.

Thank you, Crystal

 

[arnelgp]

here is a snapshot

 

[CJ_London]

for clarity, column numbers start from 0, so you are actually referencing column 1

 

[access2010]

Thank you, arnelgp for your suggestion.

We have received this= Error message
You can use the is operator in an expression with Null or Not Null

I forgot to mention that we are using Access 2003 and will be upgrading later this year.

Thank you.
Nicole

 

[arnelgp]

 

[access2010]

arnelgp, T.H.A.N.K. you your suggestion is perfect.​

​

Crystal​