Hi Norm.

If I understand your question, you have bound an option button to a logical
field on your form.  Then when you select the option as true, the field
says -1 and for false it says 0.

You need to put some code behind the button, probably in the after update
event.  Assuming the name of your option button is "button1" and your field
is "field1" try this:

if me.button1.value=true then
    me.field1.value="Y"
else
    me.field1.value = "N"
end if

I have created an example that I can send you privately if you like.  Just
send me a message.

Mike Buraczewski
[log in to unmask]


-----Original Message-----
From: Norm Thompson <[log in to unmask]>
Date: Sunday, July 04, 1999 2:38 AM
Subject: [PCSOFT] option button in Access


Can anyone tell me how to change the default -1 that appears when an
option button located on an Access97 form is clicked.I would like to
replace it with a capital letter.
Thanks
Norm Thompson

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>