I didn't mention it but I had actually tried that, along with setting the sparse property of the column to .t. before I calculated, but came up with the same error.

My problem seemed to lie in my use of the _assign method I attached to the checkbox's value property. I believe it was messing with the natural behavior of the checkbox updating the bound field. That's the best I can come up with.

I did figure out a work around using the DynamicCurrentControl and switching controls based upon the value of the field.

thanks for the help.



>>Having a problem with a checkbox in a grid. I have the checkbox in graphical mode. I set the sparse property of the column that the checkbox is in to .f. I have a calculate function that takes several of the fields in the underlying table and issues a replace statement inside of a scan…endscan.
>>I’ve tried setting focus to another control on the form before I calculate. I’ve messed with the reprocess setting. Any ideas?
>
>Try setting the grid recordsource to an empty string before doing the calculations, then re-set it back to the source afterward.
>
>Use LockScreen before & after to produce a clean interface (if needed) when altering and refreshing grid & column sources.