CODEWITHSUNDEEP
vbaexcelms-access-2007
alois
alois

Reputation: 159

Remove Checkbox in a Yes/No Field in MS Access

When I create a field whose type is Yes/No in the Design View, it appears as a checkbox. IS there a way for it to appear as words like True or False or Yes or No? I am using MS Access 2007.

Upvotes: 0

Views: 5679

Answers (2)

Philip Sheard
Philip Sheard

Reputation: 5825

Open the design view for the table, select the column and then the lookup tab at the bottom. Change the display control to text box or combo box.

Upvotes: 1

Santosh
Santosh

Reputation: 12353

Go to Lookup tab and select Display Control as TextBox

enter image description here

Now the table field Yes/No will appear as True or False. You can set the default value from General Tab.

enter image description here

Upvotes: 2

Related Questions