how simple?

[moose]

I think I must be having a blonde moment!
i have a form and on it, a combo box with two options (Yes or No)
When i select yes, it shows as -1 and when i select No it shows as 0
Can someone please tell me where im going wrong?

 

[dcx693]

Nothing blonde about it. Access internally stores True values as -1 and False values as 0. It does not store them as strings like "Yes" or "No". However, you can always format the display of the results to says "Yes", "No" or "True", "False" rather than the cryptic -1,0.

 

[moose]

How would I do that please?

I have looked through the properties of the combobox but cant find anywhere to change the display

 

[moose]

I done it
How simple was that?
Thanx for your help