option button in a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

abiba - 31 Jul 2008 19:03 GMT

i am designing a form on 2003 version. I am using the option button not the
group, but the value i get is -1 when checked. Is there a way i can get 1
instead of -1.

thanks,

Reply to this Message

Douglas J. Steele - 31 Jul 2008 19:11 GMT

No. -1 is how Access represents True.

What are you doing that the value matters?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>i am designing a form on 2003 version. I am using the option button not the
> group, but the value i get is -1 when checked. Is there a way i can get 1
> instead of -1.
>
> thanks,

Reply to this Message

abiba - 31 Jul 2008 19:25 GMT

Thanks Douglas,
I am trying to do a sum and count of observations from a monitoring form.
Is there any way i can change the -1 value to 1.

Thanks,

> No. -1 is how Access represents True.
>
[quoted text clipped - 5 lines]
> >
> > thanks,

Reply to this Message

Linq Adams - 31 Jul 2008 19:35 GMT

When you sum or count use abs()

abs(MyOptionButton)

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message