>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
Try:
thisform.pf1.p1.g1.column6.ControlSource = crs_grid.O_checkmark
thisform.pf1.p1.g1.column6.InputMask = 'Y'
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.