Re: option button (able to be clicked and displayed the user choice)

From: Rob Oldfield (blah_at_blah.com)
Date: 03/26/05 

Date: Sat, 26 Mar 2005 11:16:56 -0000

Glad you got it working, but....

You're better off using an option group with two option buttons, which has
all this functionality already built in.

"sulaiman chang via AccessMonster.com" <forum@AccessMonster.com> wrote in
message news:41cdf19787db47508239ba10c01d3b3a@AccessMonster.com...
> Private Sub Form_Current()
> If bJantina.Value = 0 Then
> optLelaki.Value = True
> optPerempuan.Value = False
> ElseIf bJantina.Value = 1 Then
> optLelaki.Value = False
> optPerempuan.Value = True
> End If
> End Sub
>
> Private Sub optLelaki_Click()
> optLelaki.Value = True
> optPerempuan.Value = False
> bJantina.Value = "0"
> End Sub
>
> Private Sub optPerempuan_Click()
> optPerempuan.Value = True
> optLelaki.Value = False
> bJantina.Value = "1"
> End Sub
>
> yup, this is solving my problem :)
> just understand what is the difference between VALUE property and TEXT
> property.
>
>
> [quote from : VBA help file]
> The Text property returns the formatted string. The Text property may be
> different than the Value property for a text box control. The Text
property
> is the current contents of the control. The Value property is the saved
> value of the text box control. The Text property is always current while
> the control has the focus.
>
> --
> Message posted via http://www.accessmonster.com