Set Field Property "DisplayControl" to CheckBox

[Phil]

Using a table's design mode, it is easy to change a
boolean field to Check box. I would have thought that
setting the "DisplayControl" field property to 106 would
do the trick.

How can I set the Display Control to Check Box using VB?

Thanks for the help.
Phil

 

[Allen Browne]

Yes, set the field's DisplayControl to 106, but the field property must be
created as in Integer:

With dbEngine(0)(0).TableDefs("MyTable").Fields("MyYesNo")
.Properties.Append .CreateProperty("DisplayControl", _
dbInteger, CInt(acCheckBox))
End With