How to return a value if results equal a number?

[ckrows]

i am new to the VBA world.

I am using a option group to give the user checkboxes.

1 = Blue
2 = Red
3 = Black
4 = Green

However using the option group it only stores the values as numbers.
I am creating a report, i cannot place the optikon group on the report because the user wants to see it as a word not a checkbox.
So i am trying to place on the report, if value =1 display the word "Blue", but i don't know how to do.

Please help!

[missinglinq]

One way would be to not bind the Option Group to the field in the underlying table, but to assign a value to the field depending on which checkbox is selected. In the example I called the field in the table Hue. Replace its name and the name of the frame holding your Option Group with your own actual names:

Private Sub YourFrameName_Click()
 
Select Case YourFrameName
 
Case 1
Me.Hue = "Blue"
 
Case 2
Me.Hue = "Red"
 
Case 3
Me.Hue = "Black"
 
Case 
 Me.Hue = "Green"
 
End Select
End Sub

Welcome to TheScripts!

Linq ;0)>

[ckrows]

Thanks Linq, it worked like a charm, this is my new standard now.