PRB: AfterRowColChange Event Code Does Not Enable Grid Cell (157855)

SYMPTOMS

If the Enabled property of a cell is changed in the AfterRowColChange event, the effect may not take place immediately. A cell that should be enabled may be disabled after moving to it from a disabled cell. Moving to a different cell in that row and back again enables the cell.

CAUSE

The Enabled property at the column level is checked upon entry to the field. If it is changed after entering a field, it is not looked at again until you leave and re-enter the field.

WORKAROUND

If you wish to disallow editing of a cell based on the contents of the cell, set the ReadOnly property to true (.T.) as shown below:

   IF numb_char.numb>80000
      This.Columns(ncolindex).ReadOnly=.F.
   ELSE
      This.Columns(ncolindex).ReadOnly=.T.
   ENDIF

Furthermore, you can change the color of the active cell by following the steps outlined in the following article in the Microsoft Knowledge Base:

129280 How to Change the Color of the Active Cell in a Grid

MORE INFORMATION

Steps to Reproduce Behavior

Create a table by entering the following command in the Command window:
CREATE TABLE numb_char(numb n(5),alpha c(5))
Fill the numeric field with some values over 80000 and some values under. Fill the alpha field with anything.
Create a new form and place the table in the DataEnvironment.
Drag the table to the form to make a grid.

Place the following code in the AfterRowColChange event:

      IF numb_char.numb>80000
         This.Columns(ncolindex).Enabled=.t.
      ELSE
         This.Columns(ncolindex).Enabled=.f.
      ENDIF

Save and Run the form. Move from row to row.

Notice when you move with the arrow keys from a disabled row to one that should be enabled, the row that should be enabled is not until you move to the left or right and back again.