I have a form with a grid that used for data entry. I the OK button I have some validation code. If a piece of data does not meet the criteria then I wan to change the color of the cell to red. One of the problems I am having is that I inserted a column so the activecol sometimes returns the wrong column number. Any ideas?
TIA!