Does anyone know how I might use the nRow and nCol parameters from the ActivateCell method to enable/disable individual grid cells?

The grid has some cells in it that do not correspond to the underlying table, and at the moment, I'm using the BeforeRowColChange Event and its nColIndex parameter to set that cell's text1.value = 0, but what I really want to do is to disable that cell entirely to avoid having the user enter an amount in vain.

Setting the text1.enabled property to .F. in the BeforeRowColChange Event always lags behind and doesn't affect the current cell, defeating my intended purpose - to streamline data entry.

I would use the When Event but I can never pin down the Active row and column to say:

thisform.thisgrid.whatevercolumn.whateverrow.text1.enabled = .F.

If only it were so easy.

Wrestling with grids (and losing),

Steve