It looks like there are at least 8 different solutions :)
Anyway, I solved the problem already and don't want to redo.
I note all these solutions for the future use.
>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?
If it's not broken, fix it until it is.
My Blog