>The RecordSource for a grid is a table. The Table contains severl fields that hold codes which don't have meaning to the end user. I have functions that translate these codes into understandable text. Those grid columns that would display the decoded informations are read only. Other columns need to be editable.
>
>I have tried putting the decodeing function as the ControlSource and putting code in the refresh for the grid's TextBox, neither work. I'm sure others do this on grids but I'm having no luck.
John,
In an editable grid any calculated column is readonly by default and cannot be made editable. For calculated columns generally it's extra parentheses that make it work. ie: For orders table you could have a form method calculating net value based on amount, discount and tax percentage :
NetColumn.controlsource = ;
'thisform.calcval(orders.order_amt,orders.order_dsc,10)'
would work. However making it :
NetColumn.controlsource = ;
'(thisform.calcval(orders.order_amt,orders.order_dsc,10))'
is more reliable.
Cetin