"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)