Yes/No in a List Box

[Glynn]

I have a Yes/No field in my Table to indicate whether a client is Active or
Inactive.
In the Tables Property I have set the Format to Yes/No - and for good
measure set the Display Control in the Lookup Proprety to Textbox.

I have then created a List Box (on a Form) to display all the clients -
hoping to see them as 'Yes' Or 'No', but instaed I get the numeric values of
"-1" or "0".
This is confusing for my Users.
I note that in the relevant Select Query the fields show as Yes and No - but
not in the Listbox

How can I get the List Box to display YES or NO. It is driving me nuts.

 

[Jeanette Cunningham]

Glynn,
create a calculated field in your query to show the Yes or No.
In a new column, in the top row, type an expression like this:
IIf([Active],"Yes", "No")
Save the query and access will put Expr1: as the name for this calculated
field.
Use this calculated field instead of the real yes/no field in your listbox
rowsource query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Glynn]

You are a pearl, Jeanette - I would never have stumbled on this solution in a
million years.

Thank you, thank you
--
Glynn

Glynn,
create a calculated field in your query to show the Yes or No.
In a new column, in the top row, type an expression like this:
IIf([Active],"Yes", "No")
Save the query and access will put Expr1: as the name for this calculated
field.
Use this calculated field instead of the real yes/no field in your listbox
rowsource query.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

I have a Yes/No field in my Table to indicate whether a client is Active or
Inactive.
In the Tables Property I have set the Format to Yes/No - and for good
measure set the Display Control in the Lookup Proprety to Textbox.

I have then created a List Box (on a Form) to display all the clients -
hoping to see them as 'Yes' Or 'No', but instaed I get the numeric values
of
"-1" or "0".
This is confusing for my Users.
I note that in the relevant Select Query the fields show as Yes and No -
but
not in the Listbox

How can I get the List Box to display YES or NO. It is driving me nuts.