>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

In the ControlSource of the Column could you:

IIF(TableName.FieldName='R','Referral','Request')