Hi Gary

No, I want to convert the checking/unchecking of a checkbox into a Y/N field. Conversely, I want the Y/N field to display as check or not. No probem, I've sorted it all in wee code snippets, while I'm douing ither stoff with each rec encountered. I originally just wanted to see if the prop's could take care of it.

>Hi Terry,
>I had a similar requirement recently, if I read your post correctly, and I solved it by using value_assign and _access methods to intercept "yY" and set it to 1, "nN" = 0 and everything else = 2 for NULL.
>
>Gary
>
>
>>Again part of the legacy system I'm changing, fopr some reason the author made a field that ellicits a Y/N answer C(1) and codes the original form to check for this, rather than making it logical. I want my new form to have a checkbox.
>>
>>Never come across this requirement before but I thought it would be achievable by putting the expression:
>>
>>=IIF( RteFam.Survey = "Y", .T., .F.)
>>
>>in the .Value property of the checkbox. It doesn't react at all. I tried:
>>
>>=IIF( RteFam.Survey = "Y", 1, 0)
>>
>>but that makes no difference either. Sure I know I can put code in a method to set the checkbox but I just wanted to do it simply, sans code.
>>
>>Why doesn't this work?
>>
>>'ppreciate it.
>>
>>Terry