Triple State Toggle Button

[Petros]

Hi all.. I want to use a toggle button to cycle 3 stages...
1. Yes 2. No 3. R

How do i do this, programmatically or by the property sheet related to the toggle button.. The control to be “toggled” is a text field..

I use this to “toggle” between two values..but the third?

If Me![TextA] = "No" Then
[TextA] = "Yes"
Else
[TextA] = "No"
End If

Thanks!

 

[boblarson]

Personally, since the third state is NULL, I would just use an option group with three options to choose from instead.

 

[Petros]

Personally, since the third state is NULL, I would just use an option group with three options to choose from instead.

Thank you, but how do i assign the letter R ?

 

[boblarson]

Thank you, but how do i assign the letter R ?

Using an option group you would assign a value of 1, 2, or 3 and whenever you need to use it you convert a 3 to an R.

For example, in a query you can use:

NewFieldName: Switch([FieldName]=1,"Yes",[FieldName]=2,"No",[FieldName]=3,"R")

 

[datAdrenaline]

... In support of Bob ... a triple state check box, radio button, or what ever is un-natural to work with in an option group. Since you are storing text anyway, a combo box is your best bet for a good user experience.

 

[boblarson]

... In support of Bob ... a triple state check box, radio button, or what ever is un-natural to work with and an option group, or (since you are store text anyway) a combo box, is your best bet for the best user experience.

Good point.

 

[Petros]

Good point.

A Combox became the result..Thanks indeed!