Set Field Property "DisplayControl" to CheckBox

  • Thread starter Thread starter Phil
  • Start date Start date
P

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
 
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
 
Back
Top