Thank you for your reply. I'm using some code to convert the data to a string. My queries are based on substrings to have the value give me both a "Met" score and a numeric score.
For Example:
Code:
Private Sub GreetOption_AfterUpdate()
Select Case GreetOption.Value
Case 1
GreetMNN.Value = "Met 5"
Label92.BackStyle = 1
Label92.BackColor = 3329330
Label94.BackStyle = 0
Label96.BackStyle = 0
Label98.BackStyle = 0
Case 2
GreetMNN = "Not Met 0"
Label92.BackStyle = 0
Label94.BackStyle = 1
Label94.BackColor = 3937500
Label96.BackStyle = 0
Label98.BackStyle = 0
Case 3
GreetMNN = "N/A 5"
Label92.BackStyle = 0
Label94.BackStyle = 0
Label96.BackStyle = 1
Label96.BackColor = 3329330
Label98.BackStyle = 0
Case 4
GreetMNN = "Not Met 2.5"
Label92.BackStyle = 0
Label94.BackStyle = 0
Label96.BackStyle = 0
Label98.BackStyle = 1
Label98.BackColor = 3937500
End Select
End Sub
I'll have to give this some thought and see if a reverse engineered solution is my best bet. It seems like it, but I may be able to get away with it how it is now, and adjusting how it looks on the form.
I think I'd rather figure out the code to have it convert the string back to match the variable, but I'm stil rather new at Access.
Thank you for your help, I'll post my findings shortly.