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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top