Hello,

i have done a search.. and found a post which half answered my problems..

I have a Table with some columns which contain Yes/No check boxes as field types.

I have a form with two unbound combo's with their rowsource property set to a Value List "0";"-1"

When I run my form I get 0 and -1 as options in the combos..how would i get Yes or No as options. (i have changed the Value List to "Yes";"No" but the query gives me an error. I also tried to set the rowsource to SELECT Distinct Car from Pupils; and this 'does' work but i dont get the ALL column. I have also tried SELECT Car from Pupils UNION SELECT "" from Pupils;

This gives me the ALL at the top..but 0 and -1 as values to choose from..

I understand that Access stores values in checkboxes as 0 and -1

so to recap..

I want to click on the dropdown combo and have a blank 1st entry.. then entry 2 and 3 will be Yes and No ..not 0 and -1

attached my db file..

kind regards

omar

You could create a lookup table
id....Desc
-1...No
0....Yes

and use that for your combo box

iv had a quick try.. but couldnt get it to work..

Which bit didn't work?

well iv never setup a lookup table.. so i think iv done the whole process incorrectly..

I tried it with the lookup method.. the Yes/No part worked.. but im not sure how i would get a blank option (select all) option..

Add
*...All

to your combo box table