Yes/No Combo Box

[jennej]

I am new to Access, I am trying to create a drop down which is bound to a bit field. I want to display Yes and No as the choices, and save 1 or 0 to the database respectively (SQL backend if it matters)

Here are the values I have
On the data tab:
Row Source: 1;"Yes";0;"No"
Bound Column: 1
On the Format Tab:


Column Widths: 0";1"

Everything seems to save in the database correctly, but when I choose a value from the drop down it isn't displayed it is just blank.

[SteveF]

I am new to Access, I am trying to create a drop down which is bound to a bit field. I want to display Yes and No as the choices, and save 1 or 0 to the database respectively (SQL backend if it matters)

Here are the values I have
On the data tab:
Row Source: 1;"Yes";0;"No"
Bound Column: 1
On the Format Tab:
Column Widths: 0";1"

Everything seems to save in the database correctly, but when I choose a value from the drop down it isn't displayed it is just blank.

In your combo box properties, what's the number in the "columns" property? It needs to be set to 2 to display the second column from your RowSource.

Steve

[jennej]

I have the
Column Count = 2

[jennej]

Thank you for you help, I figured it out with the help of a post somewhere else. It seems access doesn't do well with SQL bit types, I changed it to a tinyint and problem resolved.