Yes/No Combo's defaulting to 0 upon entry of field

[Shaunk23]

I have a tracking form that has up to 15 events.. each event has description / date & confirmed(combo box).

Combo box are set as value list - yes/no.

No =false the event hasnt happened & yes it has..

When the user is entering information and tabs through the event & date and into the confirmed combo box is changes to 0 right away.. obviously access is stating that value is no. is there a way to stop this though ?? I just want yes / no. I tried selecting all text upon entry and also dropdown on focus.

 

[VilaRestal]

That's a problem with Access Yes/No fields. They store Null as 0 (No/False).

The only way I know of is to change the data type to number (byte would do).

Then the combobox would have

• row source type: value list
• row source: 0;No;1;Yes
• bound column: 1
• allow value list edits: No
• column count: 2
• column widths: 0cm;1cm

Then it will stay as null unless the user changes it. To set it to Null from Yes or No is just a matter of deleting the text.

Apart from that you should be able to treat the field like a Yes/No field: if it's 0 it's false, if not it's true.