I need Default Value Blank in Yes/No field

[Zonie32]

I have a combo box on a form which is set up as a Yes/No field in the table design view.

On the form the default value is displayed as "No". How to I display this field as BLANK until someone actually chooses Yes or No from the drop down?

 

[ChanceD2]

I am guessing here, but I think you have the default set in the table, not in the form.

Go into the design view of your table and find that field. I'll bet you have a default value set there. Remove it.

Let me/us know if that works.

C-D2

 

[Zonie32]

Hi and thanks for your reply. My table design default value section does not have anything in it.

the Data Type is set to Yes/No. In the lookup tab section it shows the Display control as Combo Box and Row Source Type is Table/Query and Row Source section has nothing in it.

 

[ChanceD2]

BACKUP EVERYTHING FIRST....
Do this on your backup....



1. First of all, I don't ever do that at table level. I would remove that lookup and do this at the form level.
2. Create a new combo box on your form.
Do the following in the properties of the new combo box
3. Bind that combobox to the table.field
4. Row Source Type = Value List
5. Row Source = 'Yes';0;'No';-1
6. Column Count = 2
7. Column Width = ;0"
8. Bound column = 2

That should fix your problem.

Let me know.

C-D2