Control radiobutton

[sven2]

Hello,

on my report there is a field named score. Next to this field there is a radiobutton.

Now I want to make it so when the field has a value 3 the radiobutton is true else false.

what for code do I put in the recordsource of the radiobutton?

I tried iff([score])=3,true, false) but this isn't working.

Can somebody help me with this?

Best regards,
Sven.

 

[marlan]

What you wanted was a checkBox control?

 

[sven2]

Hello,

i have tried it also with a checkbox, the result is the same, it doesn't work.

On the report there is a field named score.

when I put a chackbox next to the field with the code like:

=iff([score]=3;-1;0)

the checkbox stays always false. Evan when the field has the value 3.

I can't understand why.


Sven.

 

[marlan]

The Funcion is IIf, not Iff, it is usualy helps useing the Expression Builder, I usualy do...

 

[marlan]

Just to get the syntax right: iif([score])=3,true, false)

 

[sven2]

indeed, that was the problem.

Thank you ...

 

[marlan]

Glad I could help!