>>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?)
I did that and got Data Type mismatch error. This is strange as the expression SHOULD yield T/F.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.