Yes/No Text in List Box

[Glynn]

My list box returns values of '-1' or '0', for my Yes/No fields. I want it
to return 'Yes' or 'No', not the numeric expression of the value.

In the Table I have set the datatype Yes/No to 'Text' in the Display
property, and I note that the Query on which the List Box is based - returns
the tesxt 'Yes' or 'No'.

How can I get the List Box to display the texts 'Yes' or 'No'.?

 

[John W. Vinson/MVP]

My list box returns values of '-1' or '0', for my Yes/No fields. I want it
to return 'Yes' or 'No', not the numeric expression of the value.

In the Table I have set the datatype Yes/No to 'Text' in the Display
property, and I note that the Query on which the List Box is based - returns
the tesxt 'Yes' or 'No'.

How can I get the List Box to display the texts 'Yes' or 'No'.?

Yes/True/Checked is in fact stored as -1, No/False/Unchecked as 0.

You can use a listbox with the settings:

Row Source Type: List of Values
Column Count: 2
Column Widths: 0;0.25"
Bound Column: 1
Row Source: -1;"Yes";0;"No"

 

[bhicks11 via AccessMonster.com]

Hi Glynn,

I use a Check box for yes/no. When it's checked it's yes - more more
efficient than a list box which seems better suited to more items. You use
the value however you want once your have it.

http://www.dataplus-svc.com