Worlds Dumbest Question!

[John Baker]

Hi:

I have got myself into a tangle, and think its due to a misunderstanding of the Yes/No
field definition. Can someone tell me what I test against (in a macro and code) to
determine if a Yes/No Check box is checked. I have tried 1 and 0, and results diffrer but
because its part of a much bigger problem, I cant figure out which is correct.

Happy Holiday

JOhn Baker

[Randy Harris]

"John Baker" <Ba******@Verizon.net> wrote in message
news:3i********************************@4ax.com...

Hi:

I have got myself into a tangle, and think its due to a misunderstanding of the Yes/No field definition. Can someone tell me what I test against (in a macro and code) to determine if a Yes/No Check box is checked. I have tried 1 and 0, and results diffrer but because its part of a much bigger problem, I cant figure out which is correct.
Happy Holiday

JOhn Baker

In VB, 0 is False, any other value is True. For a Yes/No field, Access uses
0 for No and -1 for Yes.

HTH
Randy

[Rick Brandt]

"John Baker" <Ba******@Verizon.net> wrote in message
news:3i********************************@4ax.com...

Hi:

I have got myself into a tangle, and think its due to a misunderstanding of the Yes/No field definition. Can someone tell me what I test against (in a macro and code) to determine if a Yes/No Check box is checked. I have tried 1 and 0, and results diffrer but because its part of a much bigger problem, I cant figure out which is correct.

In Jet tables 0 = False and -1 = True. In some other dbs True = positive 1. I
always test for =0 and <>0 which works in either situation.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[John Baker]

Thanks..that was a great help in untangling myself !

Best of wishes

John Baker