Display a checkbox field in a listbox

Topic

New Reply

There is a listbox on my form whose row source is a query.
The source of the query is a table where the display control for a Yes/No field is a checkbox.

The datasheet view of the query results, displays this Yes/No field as a checkbox. The listbox displays this Yes/No field as the text “Yes” or “No”.

How can I display the field as a checkbox in the listbox?

Reply | Quote

Replies

I hate to be the bearer of bad news but as far a I know there is no may to do this in an Access 97 list box (I’m not using Access 2000 yet so I don’t know if can be done there). I use a third party ActiveX control to list data where I need to see the check box in a column of a list box.

Reply | Quote

You can’t do it in Access 2000 either.

Reply | Quote

Could you use a subform instead of the listbox?

Reply | Quote

Or, if you’re populating your listbox from a query, use a calculated field instead of the Yes/No field and use an expression like this to replace Yes/No with X or with a space:

IIf([YESNOFIELD]=Yes,”X”,” “)

Then you would only have an X next to the ones that had a true value in the underlying field.

Reply | Quote