Link to home
Start Free TrialLog in
Avatar of hoysala
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
Avatar of clarkscott
clarkscott
Flag of United States of America image

You will add the checkbox to a form and bind the box to the field.  Checkbox is a method of displaying the data - not saving it.

Scott C.
Avatar of hoysala
hoysala

ASKER

hi Scott

i don't wan't check box on Form. instead in the Table

Rajeeva.G
SOLUTION
Avatar of onemorecoke
onemorecoke

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hoysala

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hoysala

ASKER

In Design Field Type will be Yes/No. But format will be blank and under Look up Display Control will be Text