Using Yes/No as combo box options

  • Thread starter Thread starter Allie
  • Start date Start date
A

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
 
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.
 
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.
Click to expand...

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
 
Back
Top