"Dirk Goldgar" wrote:

Hi Yoda,

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.

Humm......"relaxing" I see.
;-)

I guess I'm not one to talk.
I just got back from a vacation and I made this new Add-In while on vacation!
:-)

I was hoping to bump into some of the Canadian MVPs while visiting, but darn didn't see any.
g

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.

After testing everything (before seeing your post) I by coincidence looked up Bit in the help file
and it took me to the very topic you just discussed! It does list Boolean as a synonym. So I just
don't understand why it does not work with Boolean. Oh well, I have it working now.

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.

"Ahhh.....I see," said the Padawan.

Thanks again Yoda!
Have fun on your vacation and drop in if you are ever in Oregon!

--
Jeff Conrad
Access Junkie
Bend, Oregon
*282 Days Left*