If you really want to allow user entering Y/N then it must be character field in the cursor, and you will convert it to logical at save point.
>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
Edward Pikman
Independent Consultant