>Is it possible to do an IIF in a column to display a char value like 'n/a' if the value is 0?
>
>I have a column based on a cursor and the data is numeric. If the value is 0 I want to display 'n/a'...
>
>
>Thanks
Sure is. In your Control source for that column:
yourgrid.ColumnX.ControlSource = 'IIF(yourcondition,"N/A",amount)'