True = -1?

[Robert Blackwell]

I have this dbase from our supplier with product information, and this
latest version has a couple of changes.

Previously certain fields had check boxes, but now i'ts just -1 or
0...however, in designview it shows yes/no as the data type but it doesn't
have anything in the format box down in the general tab and the previous
version had yes/no


No big deal, just curious.

oh, and actually, my main reason for posting was cause I thought that true
was 1 and false was 0

 

[Rick Brandt]

I have this dbase from our supplier with product information, and this
latest version has a couple of changes.

Previously certain fields had check boxes, but now i'ts just -1 or
0...however, in designview it shows yes/no as the data type but it doesn't
have anything in the format box down in the general tab and the previous
version had yes/no


No big deal, just curious.

oh, and actually, my main reason for posting was cause I thought that true
was 1 and false was 0

In Access/Jet True = -1. In many other DBMS True = 1.

In VBA code ANY value that is not zero will be treated as True in a Boolean test.
For this reason I always test for = 0 and <> 0 and I have yet to come across a
situation where this has not worked as expected.

 

[Robert Blackwell]

Okay thanks.