BOOLEAN doesn't seem work in A97 or A2.0 either
-- in spite of being in the help for both versions.

I always had this theory that it was disabled because
a BOOLEAN field was an INT field in some earlier
version, but either some one told me that or it was
a total fantasy, because I never used version 1.0
to know anything about it myself.

(Testing an SQL parameter clause.)

(david)


"Dirk Goldgar" wrote in message
...
"Jeff Conrad" wrote in message
...

SecondField BOOLEAN

Nope, syntax error.
I'm still perplexed why this and dbBoolean do not work.

Hmm, I'm on vacation and don't have Access 97 installed on this laptop.
The
help file for Jet 4.0 SQL -- topics "SQL Data Types" and "Equivalent ANSI
SQL Data Types" -- tells me that BOOLEAN should work, but maybe that
synonym
for the BIT field type was not present in Jet 3.5.

I wouldn't expect dbBoolean to work. That's not a SQL field type; it's
the
name of a DAO constant, and is only meaningful when used with DAO objects.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup, not by e-mail)