field contains "Planning"?

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
 
Top