I create a table contains one field "TypesSelected" using the code of
ms access 2007 as below .
i still have on question to finish it , i need to know how can i
format this field "TypesSelected" to be such format YES/NO usind code
of ms access 2007?

Set Dat = DBEngine.Workspaces(0)(0)
Set tdf = Dat.CreateTableDef("TypeSubform")

With tdf
Set fld = .CreateField("TypesSelected", dbBoolean)
fld.DefaultValue = 0
fld.f = "Yes/No"
.Fields.Append fld
End With

Dat.TableDefs.Append tdf