If you programatically create a field object for a table, how do you set the field's type to Yes/No?
J JonWayne Jun 3, 2005 #1 If you programatically create a field object for a table, how do you set the field's type to Yes/No?
D Douglas J. Steele Jun 3, 2005 #2 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.
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.
J JonWayne Jun 3, 2005 #3 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?
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?
