Check box in Datasheet view

[Sascha]

if I create a new table with the Access wizzard, any field with type yes/no will be Display as Checkbox.

Doing the same in vba with CurrentDb.CreateTableDef and
.CreateField("FieldName", dbBoolean)

this field Shows the value such as Yes or No.

Any idea how to get that to a check box view as the wizzard does ?

 

[KenHigg]

You should be able to get to this through the TableDefs collection...

 

[Sascha]

You should be able to get to this through the TableDefs collection...

I thought so as well and checked the differences between the 2 tables via TableDef.fields("myField").properties(i)

Interesting, you do not find a difference here