Option Group does not allow selection

Question

I'm trying to insert an Option Group into my form but when I go to Form View the options won't select.  If I set the value of one of them 0, it selects.  The other I set to 1 and it won't select.  If I make the value of one 1 and the other 2, neither of them select.  The table field it is bound to is set as a Yes/No Datatype with a Text display control. 

I tried it with different display options (option buttons or toggle buttons) and I get the same behavior.

Anyone have a clue as to why this is happening? 

~Dax

Answer 1

A Yes/No field accepts either 0 (false, no, unchecked) or -1 (true, yes, checked). It won't recognize any other values such as 1 or 2.

If you make the two options -1 and 0 you should be able to use the option group.

Answer 2

Ack! me, too!

Answer 3

Try using 0 and -1. Those are the numeric values for a Yes/No field. It won't accept anything else.

Answer 4

A Yes/No field accepts either 0 (false, no, unchecked) or -1 (true, yes, checked). It won't recognize any other values such as 1 or 2.

If you make the two options -1 and 0 you should be able to use the option group.

Darn!  I was too slow...lol

Answer 5

Yes/No datatype only has two options

-1 for Yes

0 for No

If you want other options, change the datatype to Integer and then you can store other numbers.