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!

On Sat, 23 Dec 2006 16:11:01 -0800, lmv
<(E-Mail Removed)> wrote:

>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]

Thanks again John!
"John Vinson" wrote:

> On Sat, 23 Dec 2006 16:11:01 -0800, lmv
> <(E-Mail Removed)> wrote:
>
> >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]
>