Y/N Combo box

N

Nancy

I am trying to create a simple Y/N drop down (combo box). I create the field
as a text field, then change it to a combo box.

When I execute the combo box and attempt to drop down I do not see the Y/N
values.
It lets me enter anything I want.

What are the steps for creating a simple Y/N combo box and placing the valid
values into the field.

Thanks,
 
A

Allen Browne

Presumably you have a Yes/No field in your table (not a Text field), and you
want to interface it with a combo.

Set these properties for your combo:
Control Source {whatever your yes/no field is called}
Row Source Type Value List
Row Source -1;"Yes";0;"No"
Default Value False
Format Yes/No
Column Count 2
Column Widths 0
Name {whatever your yes/no field is called}
 
Top