Creating Yes/No field format programatically

[JonWayne]

If you programatically create a field object for a table, how do you set the
field's type to Yes/No?

 

[Douglas J. Steele]

How are you programmatically creating the field? Using the DAO CreateField
method, you'd use dbBoolean as the type. Using the DDL (ADD COLUMN), you'd
use YESNO. Using the Append method of the Columns collection in ADOX, you'd
use adBoolean.

 

[JonWayne]

Using DAO. I have been using dbBoolean but I get a textbox instead of a
checkbox as the control. How do I make it appear as a checkbox?

 

[Alex Dybenko]

You have to add a property "DisplayControl" and set it to CheckBox