what's the datatype for boolean in create table? 1

[SiberBob]

I have the following code:

Private Sub cmdtest_Click()

    Dim dbs As Database

    Set dbs = OpenDatabase("Y:\Databases\devcopy.mdb")

    dbs.Execute "CREATE TABLE [ROTATION] (CompanyName CHAR, Rotate BINARY)"
    dbs.Close
    

End Sub

Which creates a new table for me. How do I tell it I want the field [Rotate] to be a Boolean or Yes / No field?

 

[PHV]

CREATE TABLE [ROTATION] (CompanyName CHAR, Rotate BIT)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SiberBob]

It worked. THANKS!