>Is there a way to make the entire row of a grid change ForeColor & BackColor when a record in the grid is double-clicked??? In my form, I have put up a selection grid for the user to double-click which record he wants to edit. In the grid txtbox DoubleClick I call a StartChange method, where I handle several things and was hoping to include the color change there as well. However, at this point, I can only get one cell at a time to change in the grid. TIA, Chuck Henry
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).