Using Transform to format grid turns the control to read-only
Posted on 2011-03-16
I have a grid which allows only one row as editable, all other rows are readonly with the following code in the AfterRowColChange Procedure
The above code works and only records with the value of myfield = "Planned POs" editable
Howver, trying to format the numeric cells in the grid with the following code (either in the Init or the AfterRowColchange Procedure)
FOR i = 11 TO 41
STORE FIELD(i) TO myfield
thisform.grdMyGrid.columns(i).ControlSource= "transform(mytable." + myfield+" ,'@z 999,999')"
The above formating code does in fact format the numeric fields in the grid but turns the whole grid to read only.
Can you provide code on how to format the numeric fields without locking the one row I want to edit?