create table type

[patweb]

strSQL1 = "CREATE TABLE [T-TEMP-PWDFRAME] (PWDON TEXT(1), PWDFRAME TEXT(255), FRMNAME TEXT(255));"
DoCmd.RunSQL strSQL1

a minor flaw, I create a table, but the field PWDON is in fact a boolean and not a text. If I use text it is still working (represented true by -1), but does there exist a type in create table for boolean ? I typed boolean, but its not recognized.

regards, pat.

 

[Remou]

Would PWDON YESNO work?

 

[patweb]

I should work, the content to put into the created table is coming from a query, here is the field YESNO available.