CODEWITHSUNDEEP
ms-access
jedu
jedu

Reputation: 1341

MS Access checkbox triple state property

I know that I can disable the MS Access Checkbox's triple state property from the checkbox's property sheet.

enter image description here

By setting it to false a user can only select either true or false as the value for the checkbox.

However, everytime the form opens it looks like the default state is selected which looks something like this:

enter image description here

I think this is rather confusing for a user as this default state looks like the check box is already selected. Is there a way to make the checkbox start as blank or false?

Upvotes: 1

Views: 1052

Answers (1)

Gary Access
Gary Access

Reputation: 26

The DefaultValue in the underlying table that the checkbox or option button is 'bound' to should be set to 0. At creation of a new record, the value displayed by the control will be a blank box / option.

Upvotes: 1

Related Questions