Listview and checkbox

[D.W. Schingenga]

I have a field in my table which is a bit field (True/False), I set the view option to checkbox, this is shown in my table. I use this table to make a query and also here I see the checkbox. Now I am populating a listbox with this query. This field is not shown as a checkbox but I get the text True/False.

How can I make it work to get the Checkbox view here as well?

Thanks,

Dirk

 

[Sergeant]

Add a field to your query:
MyCheckBox: IIf([MyTrueFalseFieldName],"√","")
It won't be a real checkbox, but it's a checkmark (or whatever symbol you put in there.)

 

[D.W. Schingenga]

Listview and Checkbox.

Thanks for your reply. I understand what your solution does, however I do not know where I have to put it in this line.

Please tell mee where to put in this line.

Thanks,

Dirk

 

[Sergeant]

In your query, replace the true/false field name with the iif statement that I provided. Change the part that says "MyTrueFalseFieldName" with the actual name of your true/false field.

 

[D.W. Schingenga]

Listview and Checkbox.

I am a bit further but not there yet. The IIF command does not work, because I am using SQL server for the data. Looking on the Internet I need to use a CASE expression, however I can nog get this in without error messages. I try to apply this in the Query screen of Access. I think that this will not work here, but I am not sure.

So need some help to get this done.

Dirk