PDA

Click to See Complete Forum and Search --> : Creating boolean field in Access table


michelle
Jan 11th, 2000, 05:16 PM
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
Jan 11th, 2000, 06:41 PM
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