Table True False Checkbox

[Tuckejam]

Sorry I cant seem to find the answer to this anywhere, Seems like it should be easy but I cant figure it out.

I have a table with a Yes/No field and access has automatically made it into a checkbox on/in the table.



How can I make that be either True/False text or 1,0 values instead of showing the check box?

Thanks

[kd2017]

In the table designer look at through the tabs for the field.

That said you shouldn't let your users work directly in the tables, you should work in a form. There you can use a text box, check box, combobox, listbox, whatever you like. You can make a "data sheet" form that looks like a table or spreadsheet.

[ranman256]

all these values are the same in Access:
true/false
1/0
yes/no

but NOT in text: "TRUE" or "FALSE"
true/false is numeric, so you cant use text, its a checkbox.

you COULD use a combo box that has 2 values, the 1st is your 'text' , and the 2nd is the numeric value which is bound to the field:
"TRUE",-1
"FALSE", 0