Conditional Formatting more than 3 Conditions

[jereece]

I am using MS Access 2007. Traditionally, Conditional Formatting has been limited to 3 conditions. Is there a way to have more?

I have a report with a Priority Code field. Priority x1xx, x2xx and x3xx. I want all of the x1xx (e.g. I1a, O1ba, I1cd, etc.) to show red with yellow text and the x2a (e.g. O2a, I2a, etc.) to show yellow. Since I will have more than 3 conditions I am not sure how to make this happen.

Would it work if I use between (e.g. between A1a and Z1z = Red and between A2a and Z2z = Yellow)? It would be nice if a wild card worked (e.g. *1*) but I tried.

As always, I appreciate the help.

Jim

 

[Beetle]

As long as each record can only have one occurence of a numeric value in the field (i.e. - you would never have something like I1a2) then you could use the InStr function in conditional formatting;

Expression Is: InStr([PriorityCode], "1") > 0
'do something
Expression Is: InStr([PriorityCode], "2") > 0
'do something else

You would still, however, be limited to 3 overall "conditions"