hoysala
asked on
MS Access Add a Boolean type Column
hi
i am Adding a boolean type Columng to Access Table. But after executing below mentioned code, in design instead of Check Box, 0 will appear. Is there any way to set Lookp to check Box.
strInsert = "ALTER TABLE UnitRecurCharges ADD COLUMN urc_bln_InsCancelDayEnd Bit "
db.Execute strInsert
i am Adding a boolean type Columng to Access Table. But after executing below mentioned code, in design instead of Check Box, 0 will appear. Is there any way to set Lookp to check Box.
strInsert = "ALTER TABLE UnitRecurCharges ADD COLUMN urc_bln_InsCancelDayEnd Bit "
db.Execute strInsert
ASKER
hi Scott
i don't wan't check box on Form. instead in the Table
Rajeeva.G
i don't wan't check box on Form. instead in the Table
Rajeeva.G
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No This also doesn't works. It will put Yes, Instead of 0. Also the under Look up Display Control shows Text box only. Is there any way so that we can change Display control to Check Box insetad of Text Box.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In Design Field Type will be Yes/No. But format will be blank and under Look up Display Control will be Text
Scott C.