David,
I am using your class which highlights the whole row in a grid. It is working but I would like to understand some things about it in order to tweak it to work in my environment. I will describe what I would like to do, then ask some questions.

A. On my form I have 3 grids that look like 1. ( It really looks cool!) When the user selects a row in one of the upper 2 I want to highlight the row in the current grid, and turn off the highlight in the unselected grid.

B. If the user clicks on a column whose index is less than 2, I want to display a message saying they must click in a column > 2.

C. Now the tricky parts: When they click on a column, I want that column to stay the same color as the rest of the row and

D. I want to give them the ability to double click on a valid column and bring up an editing form.

In the textbox bound to the column of the grid I have a DblClick event code that works fine w/o the highlight class, but doesn't function with it. Also, when they click on another column in the same row, the highlight turns off. Normally in my grids AfterRowColChange event I grab the ActiveColumn and ActiveRow, as well as the columns controlsource.

1. What is the necessity of the Grid When and Grid Valid methods? The When is especially troublesome while using the debugger!

2. Why the use of RelativeRow instead of ActiveRow?

3. My grids only have vertical scrool bars. Is the DoScroll and Scrolled events necessary?

4. Because I have other objects on the screen, is there a way to limit the number of calls to the When, Valid, AfterRowColChange, BeforeRowColChange, and other like events that fire 10 gazillion times a second. ( this is an attempt at humor! <bg>)

Any help you can give would be greatly appreciated.

Michael Haggerty
amkhag@erols.com
haggertm@pwba.dol.gov