Combo Box showing different result to Query

[euphonium01]

I have a form with a Combo Box on one of the Fields, when I click it I get my list of items. One of those items is to tell me if a particular item is 2nd Hand or not, this is a simple Yes/No field. When I open the Form and drop the Combo Box list, I get "True" or "False", I would like the dropped list to display the Yes/No check box rather than True or False, how do I do that? When I run the Row Source Query that 'supplies' the Combo Box I get the check box no problem, but not when I click the Combo Box with the Form open?



I've tried setting the Format value in the Query Properties to Yes/No and saved it, but when I go back to it, it hasn't saved the Yes/No Format, and continues to give me "True" or "False" with the Form open? Soooo frustrating! Thanks in advance for any help.

[ranman256]

Instead of using the native field, use an IIF
=IIF([myField],"Yes","No")

[euphonium01]

Exactly as the previous problem I had ranman256, you got the answer in one, thank you