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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"JonWayne" <(E-Mail Removed)> wrote in message
news:SnNne.46326$(E-Mail Removed)...
> If you programatically create a field object for a table, how do you set
> the
> field's type to Yes/No?
>
>

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?


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "JonWayne" <(E-Mail Removed)> wrote in message
> news:SnNne.46326$(E-Mail Removed)...
> > If you programatically create a field object for a table, how do you set
> > the
> > field's type to Yes/No?
> >
> >
>
>

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

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"JonWayne" <(E-Mail Removed)> wrote in message
news:0%One.40206$(E-Mail Removed)...
> 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?
>
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "JonWayne" <(E-Mail Removed)> wrote in message
>> news:SnNne.46326$(E-Mail Removed)...
>> > If you programatically create a field object for a table, how do you
>> > set
>> > the
>> > field's type to Yes/No?
>> >
>> >
>>
>>
>
>