>>>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
>>
>>Terry,
>>
>>In the properties, try [ UPDATE, in the controlsource this is ]
>>

>>(RteFam.Survey = 'Y')
>>

>
>Thank you, Gregory
>
>I assume you mean in the .value property (if not, which else?)

In the ControlSource of the checkbox !! (see UPDATE above)

>I did that and got Data Type mismatch error. This is strange as the expression SHOULD yield T/F.