Hi Kevin,
One solution is to handle this in your SQL statement.
SELECT Field1, Field2, IIF(InfoType = "R", "Referral", "Request ") AS InfoType,...
>Hi
>
>I am using a Select statement to populate a Grid, but in the one of the columns I want to check the value of a field in the select.
>
>I have placed code in the Textbox in the Column saying:
>
>
IF this.Value = "R"
> this.Value = "Referral"
>ELSE
> this.Value = "Request"
>ENDIF
>
>
>But nothing happens, do I need to change something, the Select is selecting into a cursor.
>
>Thanks
>Kev
Charlie