Database Discussion - Option button in MS Access 2003

Print Page | Close Window

Option button in MS Access 2003

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14896
Printed Date: 29 March 2026 at 8:34pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Option button in MS Access 2003

Posted By: Tanya
Subject: Option button in MS Access 2003
Date Posted: 01 May 2005 at 3:39am

Hello!

Please, HELP ME!

I have a BIG problem with option button in MS Access 2003. I'm trayng to make an option group with five option buttons with options value for witch one - -1, 0, 1, 1.5, 2. But Access can't accept in Property window option value 1.5! Access make it round in 2 automaticly!!! But I need option value 1.5!

How I can change the settings? I can't found it!

Please, someone help me!

Replies:

Posted By: Mart
Date Posted: 01 May 2005 at 3:46am

Round it your self before you insert it



Dim RawValue

Dim RoundedValue



RawValue = 1.5

RoundedValue = Round(RawValue)

Then insert RoundedValue instead of RawValue

Posted By: Tanya
Date Posted: 01 May 2005 at 3:56am

Thank you very mach, Mart!

But I don'n know where I have to write this code. I'm sorry, can you explain me? I will be much obliged!

Posted By: Mart
Date Posted: 01 May 2005 at 6:05am

You will have to post the code here if you want me to tell you where to insert it

Posted By: Tanya
Date Posted: 01 May 2005 at 8:43am

This is the code for the option button, wich I want to get option value 1.5:

Private Sub Option108_GotFocus()
End Sub

Private Sub Option108_LostFocus()

End Sub

Posted By: dpyers
Date Posted: 01 May 2005 at 12:16pm

I think Mart would need to see the code where you post the option to the db.

-------------

Lead me not into temptation... I know the short cut, follow me.