>As Barbara pointed out, you can use DynamicForeColor (or DynamicBackColor). I've only just done this. I had an option group and textbox to do a search. In the textbox valid event I just put Grid.SetAll("DynamicBackColor","IIF(match_criteria,RGB(0,255,255),RGB(255,255,255))","Column"). That set the back color to CYAN for all matching rows. I had to do a lot of playing to get it right (moving quotes around, etc).


I've tried this and variations on it in the textbox valid, and various refresh methods - response = zilch! (even with your code cut and pasted into said textbox.)

Is there some other property we need to set before this trick will work?

Harry