CODEWITHSUNDEEP
ms-accessdatabase-designms-access-2010default-value
Katie
Katie

Reputation: 105

Setting default value for Yes/No Data Type in Access table

I have a Yes/No checkbox in one of my Access tables. I'd like the default to be 'Yes', so that the box is checked by default. I cannot get it to work. This is my selection so far in Design View.

enter image description here

Am I missing something? The Datasheet View shows all of the checkboxes unchecked with these settings.

Upvotes: 2

Views: 4064

Answers (2)

HansUp
HansUp

Reputation: 97101

Change the field's Default Value to -1, Yes, or True.

You asked ...

Am I missing something? The Datasheet View shows all of the checkboxes unchecked with these settings.

Beware the Default Value is not applied to existing records. It only affects new records when you don't explicitly supply a value.

Upvotes: 1

Erik A
Erik A

Reputation: 32642

Default values are supposed to be valid expressions, starting with =.

Set the default value either to =Yes or to =True to make checked (Yes) the default.

Upvotes: 1

Related Questions