field contains "Planning"?

  • Thread starter Thread starter Kirstie Adam
  • Start date Start date
K

Kirstie Adam

hi all,

i have a field called status, which can have a few different values, eg.
"Pre Planning", "Planning", "Plannning Appeal"

i want to use conditional formatting on a continuous form to say that if the
[STATUS] field contains the word "Planning" the backcolor will show as
orange. (therefore showing all 3 stages as noted above as Orange, although
they are 3 different things)

if there is an alternative way to do this through code, that would also be
welcome.

can someone help?

kirstie
 
Hi Kirstie,

Conditional formatting can do this for you. The way to get it to work is to
select "Expression is" in the first drop-down, then enter
[STATUS] Like "*planning*"
in the large textbox, and select the background colour you want. Neither
the field name nor the text string are case sensitive.

HTH,

Rob
 
Rob,

Great, thamks. So simple too!

I had been trying

[STATUS] = "*Planning*" and gettting frustrated when it wasn't working!

Kirstie

Rob Parker said:
Hi Kirstie,

Conditional formatting can do this for you. The way to get it to work is
to select "Expression is" in the first drop-down, then enter
[STATUS] Like "*planning*"
in the large textbox, and select the background colour you want. Neither
the field name nor the text string are case sensitive.

HTH,

Rob

Kirstie Adam said:
hi all,

i have a field called status, which can have a few different values, eg.
"Pre Planning", "Planning", "Plannning Appeal"

i want to use conditional formatting on a continuous form to say that if
the [STATUS] field contains the word "Planning" the backcolor will show
as orange. (therefore showing all 3 stages as noted above as Orange,
although they are 3 different things)

if there is an alternative way to do this through code, that would also
be welcome.

can someone help?

kirstie
Click to expand...
Click to expand...
 
Back
Top