Triple State Toggle Button

Petros · Jul 10, 2010

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 · Jul 10, 2010

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

Petros · Jul 10, 2010

boblarson said:
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 · Jul 10, 2010

Petros said:
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:

Code:

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

datAdrenaline · Jul 11, 2010

... 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 · Jul 11, 2010

datAdrenaline said:
... 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 · Jul 11, 2010

boblarson said:
Good point.

A Combox became the result..Thanks indeed!

Triple State Toggle Button

Petros

Registered User.

boblarson

Smeghead

Petros

Registered User.

boblarson

Smeghead

datAdrenaline

AWF VIP

boblarson

Smeghead

Petros

Registered User.

Similar threads

Users who are viewing this thread