Yes/No in a List Box

G

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top