Access Option group question

[Guest]

In using an option group, is there a way to set the option value at 1.5, 2.5,
etc.?

 

[fredg]

In using an option group, is there a way to set the option value at 1.5, 2.5,
etc.?

No. The value of an Option Group is an Integer, which by definition is
a whole number.
What possible difference could it make if the values were 1, 2, 3 or
1.5, 2.5, 3.5?

 

[UpRider]

Fake it and make it whatever you want.

Private Sub cmdRun1_Click()
Dim strFake as string
Select Case grpMyGroupOpt.Value
Case 1
strFake = "1.5"
Case 2
strFake = "4.00004"
Case else
strFake = "beats me"
End Select
End Sub

HTH, UpRider

 

[Guest]

Will I be able to use the numbers for calculations if I "fake it"?

 

[UpRider]

Sure. You can dim strFake as a number. Remove the quotes from after
strFake =, and calculate away.

 

[Guest]

Thanks--I will let you know how it works

Sure. You can dim strFake as a number. Remove the quotes from after
strFake =, and calculate away.