Conditional Formatting in Code

[new_2_prog]

I have a form based on a table which in design view looks like 1 line but in form view has multiple lines because depending on the ID number depends on the description.
What I want is when the form opens that the background of the field ID to change to blue if the ID = 9, 12, 19, 27, or 30.
When I am in form view I went to "Format", "Conditional Formatting" but I am only allowed 3 conditions and I need 5 unless there is a way to combine them into 1 (I tried 9 or 12 or 19 or 27 or 30) but it didn't work.
thanks.

 

[boblarson]

Just use

Expression IS

instead of VALUE IS

and then use this

[YourFieldNameInSquareBrackets] In (9, 12, 19, 27, 30)

 

[HiTechCoach]

Another option for the expression, something like:

[YourField] = 9 or [YourField] = 12 or [YourField] = 19 or [YourField] = 27 or [YourField] = 30

 

[new_2_prog]

Another option for the expression, something like:

[YourField] = 9 or [YourField] = 12 or [YourField] = 19 or [YourField] = 27 or [YourField] = 30

This one worked perfect and to the first posted reply THANKS I forgot about switching to use the expression - I haven't done this in a while for Excel or Access.

 

[boblarson]

This one worked perfect and to the first posted reply THANKS I forgot about switching to use the expression - I haven't done this in a while for Excel or Access.

So the IN clause didn't work?