Using Yes/No as combo box options

[Allie]

Is there a way to only show YES and NO as the choices in a
combo box without showing the default -1 and 0 also?

I would like the user to choose Yes or No and the value
stored in the table to be -1 or 0.

Thanks

 

[Michael S. Montoya]

Set the combobox RowSource Type to ValueList
Make the RowSource 0,"No",-1,"Yes"
Make the column count 2
make the columnwidth 0,1,0,1

That should take care of it.

 

[Bullschmidt]

Set the combobox RowSource Type to ValueList

Make the RowSource 0,"No",-1,"Yes"
Make the column count 2
make the columnwidth 0,1,0,1

That should take care of it.

And on a search form I sometimes like to add *:
Make the RowSource "*","*",0,"No",-1,"Yes"

And then use Like in the query:
Like [Forms]![MyForm]![MyYesNoSearchField]

Best regards,
J. Paul Schmidt, Freelance Access and ASP Developer
www.Bullschmidt.com/Access - Sample Access Database
www.Bullschmidt.com/login.asp - Web Database Demo