Hi Nadya

There are at least two solutions. First use the _assign method to change the value displayed in the text box to "Yes" or "No". Then use the access method to return IIF(This.Value="Yes",.Y.,.N.)

The second solution is to use a comobox with rowsource="Yes,Y,No,N" and then use the _assign method to return IIF(This.Value,"Y","N").

I use the second solution all the time.

Simon White



>Hi everybody,
>
>How can I set controlsource for the textbox with the logical field to show Yes/No instead of T/F ?
>
>I tried to put iif(myField,'Yes','No'), but it doesn't allow me..
>
>How can I do it?