Checkbox Yes/No/... ?

[SeanD]

Hi all,

I'm a little familiar with Access.
If you have 3 possible values for a field, u can use format property text and add as validation ="Value1" OR "Value2" OR "Value3".
Is there a way to do it with a checkbox who has 3 values?
The checkboxes Yes/No, True/False, .. have only 2 values.

Any idea's?

Thanks a lot!

 

[Galaxiom]

Maybe what you really want is an Option Group.

 

[SeanD]

I know what you mean. In a form it is possible.
I have 3 options.
1, 2 and 3
1 = Yes, 2 = No, 3 = Unknown.
If I want to add these values into the table I need to work whit ifs:

If blabla = 1 Then
Blabla = "Yes"
ElseIf blabla = 2 Then
Blabla = "No"
...

Then I Insert all the data with SQL.

But if they want to see and update these values, I need to do it reverse.

It's a little complicated. So I search for a better way.

 

[Galaxiom]

The Option Group will do it whether it is as a bound control or by VBA/SQL.

The Option Group has a Value property that represents the current selection of the group.

Otherwis you could do it in a combobox where the user chooses Yes/No/Unknown from a dropdown list.

 

[SeanD]

Drop down list is a bit a lot of work to enter all the 100 values
Thats why i wanted check boxes.
The value property only accepts numeric values ?

 

[Galaxiom]

Just try placing an Option Group and follow the Wizard. They are very versatile.

 

[Galaxiom]

Drop down list is a bit a lot of work to enter all the 100 values

BTW. Just wanted to check. If you are entering yes/no/unknown into 100 different controls on the form to be fed to 100 different fields then you have not properly structured the data.

 

[gemma-the-husky]

Drop down list is a bit a lot of work to enter all the 100 values
Thats why i wanted check boxes.
The value property only accepts numeric values ?

if you have lots of values, and the values may change - then you most likely DO want a drop down list - but you need to get the values by querying another table - not by entering the list directly

then you have another form to edit the table that drives the drop down list

doing it this way, means you dont have to touch your code again.