2 ITEMS in Cond Format

[Guest]

I have conditional formatting on a field that works ...
control source on a txt box =[Status]
I have it set "field is equal to" "ACTIVE"
and this works but I actually have 2 values that should have the same
formatting and I have already used up the other 2 formats.
Is it possible to have 2 items in this conditional formatting field and what
would the code be if I changed it to expression? Or how do I put 2 into the
same field?
I tried the following and none worked: (because I don't know VBA well enough
duh!)
"ACTIVE" or "MOVED"
"ACTIVE", or "MOVED"
"ACTIVE"; or "MOVED"
("ACTIVE") or ("MOVED")

Thanks...AGAIN!

 

[John Vinson]

I have conditional formatting on a field that works ...
control source on a txt box =[Status]
I have it set "field is equal to" "ACTIVE"
and this works but I actually have 2 values that should have the same
formatting and I have already used up the other 2 formats.
Is it possible to have 2 items in this conditional formatting field and what
would the code be if I changed it to expression? Or how do I put 2 into the
same field?
I tried the following and none worked: (because I don't know VBA well enough
duh!)
"ACTIVE" or "MOVED"
"ACTIVE", or "MOVED"
"ACTIVE"; or "MOVED"
("ACTIVE") or ("MOVED")

Thanks...AGAIN!

Ratner than "Field is equal to" use "Expression", and set the
expression to

[Status] IN ("Active", "Moved")

John W. Vinson[MVP]

 

[Guest]

Thanks again John!

I have conditional formatting on a field that works ...
control source on a txt box =[Status]
I have it set "field is equal to" "ACTIVE"
and this works but I actually have 2 values that should have the same
formatting and I have already used up the other 2 formats.
Is it possible to have 2 items in this conditional formatting field and what
would the code be if I changed it to expression? Or how do I put 2 into the
same field?
I tried the following and none worked: (because I don't know VBA well enough
duh!)
"ACTIVE" or "MOVED"
"ACTIVE", or "MOVED"
"ACTIVE"; or "MOVED"
("ACTIVE") or ("MOVED")

Thanks...AGAIN!

Ratner than "Field is equal to" use "Expression", and set the
expression to

[Status] IN ("Active", "Moved")

John W. Vinson[MVP]