Form Yes/No combobox

[ketangarg86]

Hi,

I have a combo box that retrieves values from a table column. The values could be blank, yes, or no. Now the combo box displays the yes/no values in the dropdown but when I select "No", it fills the combo box with 0 and "Yes" fills it with -1. The query and everything runs good. Is there a way I can displya Yes/No instead of -1/0 to the user of the form.

Thanks a lot for your help.

[ranman256]

In the combo format, chg to: yes/No

[ketangarg86]

Yes, I tried that but then the blank values are also treated as a "No". The column in the table could have blank, yes, or no values..

[ranman256]

Blanks SHOULD be treated as NULL but emptyset "" could be interpreted as no.
You may have to force the issue in the list ,before you run the query set the combo to NULL if cbo ="". or len(cbo) = 0

BUT your table could have a default value = 0. Make sure is dont, else all nulls will = 0.