MS Access Option Group QA

This video is in response per a question about the
ms access option group I received:

“Hello, I have a question: can we store a decimal value in the option value??
Like if I want to put the value of yes = 0.25 and No= 1.25 is it applicable?? please
help”

Take a look at this example and see if
it helps deal with the issue.

[sourcecode language=”vb”]
‘========================================================
‘DATABASE DESIGNED & CODED BY LOEBLCOM SERVICES 2013
‘ERIK LOEBL(713)409-7041
‘EMAIL: erik@loeblcomservices.com
‘WEB: http://loeblcomservices.com
‘========================================================

Option Compare Database

Private Sub btnValue_Click()

Dim dblValue As Double

Select Case Me.fraProducts
Case 1
dblValue = 0.25
Case 2
dblValue = 1.25
End Select

MsgBox dblValue

End Sub

[/sourcecode]

Click here for the database and the code:
ms-access-option-group.accdb

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags:




 

Call Erik Now