Hi Fred,

Thanks for the reply. I tried it and it works... Great

Thanks

>>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)'