Issue displaying Yes/No field. 1

[egstatus]

Hi Everyone.
I have a Yes/No Field for which I store the values as -1/0.
I display the field in a combobox and they are displayed as Yes/No. The combo box has a list value with 2 entries, "Yes" and "No" with a Default of 'No'. Entering the information in the combobox work as intended, However if I click inside the combobox I see either a 0 or -1. As soon as I leave the combobox the combobox displays either Yes/No. How can I prevent showing 0/-1 when user clicks inside the combobox?

Any Idea why access shows 0 or -1 if I click inside the combobox?


Thanks

EGStatus

PS because of form requirements I have to use a ComboBox.

 

[dhookom]

I expect you need to change the row source and other properties of the combo box.

[pre]Row Source Type: Value List
Column Count: 2
Row Source: -1,"Yes",0,"No"
Bound Column: 1
Column Widths: 0, 0.5"[/pre]


Duane
Hook'D on Access
MS Access MVP

 

[egstatus]

Thanks.
Problem solved.