Creating boolean field in Access table

[michelle]

Dear VB programmers,

Last question was wrong!!

I want to create i a Access database a table with a boolean field.

Set Ws = DBEngine.Workspaces(0)
Set Db = Ws.CreateDatabase("c:\new.mdb", dbLangGeneral)
Db.Execute "Create Table NewTable ( NewField Text);"

The field NewField will now be the data type text.
What do I have to fill in to get the field NewField boolean?

Nice regards,

michelle.

[Mark Sreeves]

Db.Execute "Create Table NewTable ( NewField yesno);"

works but doesn't set the format...

------------------
Mark Sreeves
Analyst Programmer

Mark.Sreeves@Softlab.co.uk
A BMW Group Company