True = -1?

  • Thread starter Thread starter Robert Blackwell
  • Start date Start date
R

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
 
Robert Blackwell said:
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
Click to expand...

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.
 
Back
Top