How do I set DisplayControl on Boolean when creating new table?

[Komatose]

My Problem is that I created a table with

create Table tablename (ItemBox LOGICAL)

and the DisplayControl (under LookUp) is set to Text but I need a Check Box! Does anyone know how to set it to Check Box via command?

Thank you for your answer!

Yours Michael

 

[p7eggyc]

Moving this up to the top of the list so I can see if anyone today might have an answer for this problem. I am having the exact same issue and need the fields in the table to be set to check boxes. Thanks for any help!

Peggy

 

[p7eggyc]

Here's the answer I found for future reference:

dbBkEnd.TableDefs(strTableName).Fields("EEE&quot.Properties.Append dbBkEnd.TableDefs(strTableName).Fields("EEE&quot.CreateProperty("DisplayControl", dbInteger, 106)

where dbBkEnd is a database variable, strTableName is a string variable holding the name of the table you are adding the field to and EEE is the name of the field you added.

Hope that helps someone in the future!

Happy Friday,
Peggy