>Hi. VFP7 user. In a grid, I have a field called 'freight'
>If the freight > 0, I want the freight column (of the grid) to display 'Y'
>Else, I want the column empty.
>
>Keep in mind that this is a field in a grid and it seems that every column has to have a control source.
>
>Thanks, Randy
>
>ps: one way that I thought of was to populate a field in the init of the field?? Is there a way with less overhead?
>r
If this field is for display purpose only, put iif(myTable.freight>0,'Y'," ") in a ControlSource field and set sparse property of the column to .f. (it may work without it as well)
If it's not broken, fix it until it is.
My Blog