List box not showing check boxes

[shenty]

I have created a list box that shows several columns of information from a query, 2 of these columns are check boxes that appear as check boxes in the query but in the list box they are shown as either a 0 or -1. !!

Can anyone tell me how to get check boxes shown as check boxes in a list box. I can send the mdb file to anyone who needs to see it.

Thanks for help in advance.

 

[ted.martin]

Not sure you can do that. What may be acceptable is to create a pop-up form in datasheet view. That will show the check boxes as boxes (like in the table) but of course you can put some code behind the 'click event' of each of the columns that will select the row you require and enter that into your list box.