Combo Box Default Value

[locosh]

Hello,

I am using a combo box in a form to look values from a query. The field in the query is a Yes/No field.

There is a Property called Default Value when I right click on the combo Box and select Properties. I am trying to set this default value for the combo box to "No", but it keeps showing as 0. Any ideas?

Thanks!

 

[JerryDennison]

Why would you use a combobox for a Yes/No or boolean field? Anyway, the reason it's showing as 0 is because this is the value that Access uses to denote False. If you'll change the field to a checkbox or textbox with it's format property set to Yes/No you should get the result you're looking for.