I'm trying to set the column that is displayed as logical field to accept Y/N and display Y or N instead of T/F. This is a readwrite cursor that is shown in the grid as follow:

SELECT P_productname, O_orddte, O_qty, ;
Sum_rd_qtyrec, O_unitprice, O_checkmark, O_tmp_qtyrec, ;
O_tmp_daterec, O_tmp_amt, O_orderid, O_p_productid ;
from lv_order_by_dte_nrp INTO CURSOR crs_grid readwrite

SELECT crs_grid
thisform.pf1.p1.g1.RecordSource="crs_grid"
thisform.pf1.p1.g1.RecordSourceType = 1
thisform.pf1.p1.g1.column6.ControlSource = "=TRANSFORM(crs_grid.O_checkmark,'Y')"

However, I keep getting errors when setting the controlsource for the column. The user will be entering a Y or N into the columns. Why can't I set the controlsource? Is there another way of doing this? The cursor field name is crs_grid.O_checkmark.

Thanks
Nick