Help with conditional formatting

[Leopardfist]

No, instead of a checkbox saying that yes they are desigtnated, they want a textbox where we enter the designation code. The formatting will format if the text box is NOT empty.

So if the text box has "BSY" or "WCBY" it will highlight... but if it is blank it will not.

Would this work?

Reports![SHU Monitor Roster Designated]![Two-Hour Watch].Text != ""

Is != the operator for not equal to?

 

[KenHigg]

<> is not equal

I suppose this would work as long as you don't have any nulls...

 

[Leopardfist]

Ken,

I can't thank you enough for the help, I appreciate it more than I can say!!!

 

[KenHigg]

Glad to help - Whew working 3 or 4 threads at a time is tuff. Think I'll bail out for a while.