>> Waheed .
>> using a view is not the only way - u can put an expression as the
>> controlsourse I've done it before and it works
>>
>> Arnon I had tried to set controlsource property of grid column as
>IIF(file.nField=1,'xxx',yyy'), it give me an error, I will be thankful if u can explain
>me how u r able to do this.
>
>Thank Q
>Waheed

have you tried iif(this.value=1,'xxx','yyy') ?