Unbind the checkbox from the ControlSource and put this code in the InteractiveChange() event: REPLACE MyField WITH IIF(THIS.Value, "Y", "N") IN MyView

HTH

---

>I have a grid mapped to an Oracle remote view. One of the columns is a 1-char field containing either Y or N. I want to control this with a checkbox field, which takes only .T./.F. or 1/0.
>
>I tried adding a calculated field to my view, which has lead to all sorts of headaches, and I have decided that there must be a better way.
>
>Can anyone suggest a nice elegant way to transform this Y/N controlsource into a checkbox ?