CONDITIONAL FORMATTING

[gambler844]

When i put the following formula in condition 1, it wont flag my field back
and white when this condition occurs. ([ncourse1] not like "mt*" or
[ncourse1] not like "it*")
Please tell me what im doing wrong?
Thanks
ed

 

[Duane Hookom]

Try using OR rather than AND.

 

[gambler844]

-- Im a little confused. I did use or instead of and. Im i missing something?
Thanks for the help
ed
thanks

 

[Duane Hookom]

Just switch them and see if it works.

--
Duane Hookom
Microsoft Access MVP

-- Im a little confused. I did use or instead of and. Im i missing something?
Thanks for the help
ed
thanks

When i put the following formula in condition 1, it wont flag my field back
and white when this condition occurs. ([ncourse1] not like "mt*" or
[ncourse1] not like "it*")
Please tell me what im doing wrong?
Thanks
ed