Check Box to Combo Box

[Yakisobi]

Let me first say I am not a programmer...so please reply back in simple terms



I created a yes/no field which populated as a checkbox on my form.
The default value is set to False.

I then went in and changed field from yes/no to a combo box with a drop down option of yes/no/unknown.

However, when I did this, the default value brought over is "no" despite deleting my default value of 0.

Is there any way to correct this problem? I want my default value to be blank, like it is for a field when I create it as a drop down option upfront.

Thanks in advance!

[NTC]

the key question is what is the field at the table level?

if this is a brand new design with only test data - making a change is ok. if this is a populated database with real data - making the change needs to be done with care and fore thought.

one doesn't need to be a programmer - but one does need to have an Access textbook. a default value can exist at the table level, and/or at the form level. when changing from a checkbox to a combobox - you want to make the change at both levels also.

hope it helps a bit.