yes/No -1,0

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I have a table with a yes/no field and on a form I want to search by that
field. If I set the textbox data to value and put yes, No the textbox
displays Yes or No as it should but the search fails. If I put -1, 0 as the
values, the search works as it should. Isn't there an easy way to make the
No get evaluated as 0 and so forth?
 
I have a table with a yes/no field and on a form I want to search by that
field. If I set the textbox data to value and put yes, No the textbox
displays Yes or No as it should but the search fails. If I put -1, 0 as the
values, the search works as it should. Isn't there an easy way to make the
No get evaluated as 0 and so forth?
Click to expand...

Several. One would be to use a Combo Box with a rowsourcetype Value
List, RowSource -1;Yes;0;No , ColumnCount 2, ColumnWidths 0,0.25.
Another would be to use an Option Group control with two buttons,
values -1 and 0, labels Yes and No.

John W. Vinson[MVP]
 
Back
Top