>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
John,
If you do that with a readonly cursor then iif() for a controlsource would work. OTOH if you want to have it for an editable grid then I think you should use DynamicInputMask + another textbox control.
myGrid.myColumn :
.Controlsource = "myTable.myField"
.CurrentControl = "Text2"
.DynamicInputMask = "iif(myTable.myField=0, 'N/A','999,999.99')"
.Text2.InputMask = '999,999.99'
Cetin