Combo box shows values, but won't select last few

I have a combo box that is based on a query that displays 19 records in the
query and all 19 values are displayed in the combo box's drop down list.
However, I can only select the first 16 values in the list to be returned to
the combo box. Is there a property setting or something else that is
limiting this box to the first 16 values?

There is no such restriction. What happens if you enter them manually via the
keyboard? (This should work either way, but you may want to try it with Limit
To List = Yes as well as with No.)

Sebastian

Nick,

I suspect that the Bound Column value in the last three records has a
duplicate value to one of the first sixteen. For example, consider the
following records as the row source of the combo box, selecting both columns,
with the first one bound:

ID Value
------------ ------------------------
1 Margie
2 Tom
3 Susie
4 John
4 Billy

Billy will not be able to be selected, because when chosen, ID = 4 is
written to the control. I'm not sure how Access processes this, but when I
test this, John is displayed after selecting Billy from the drop-down list.

This is a good reason to include the primary key from the table in any
RowSource, and use it as the BoundColumn.

Hope that helps.
Sprinks


"Nick" wrote:

I have a combo box that is based on a query that displays 19 records in the
query and all 19 values are displayed in the combo box's drop down list.
However, I can only select the first 16 values in the list to be returned to
the combo box. Is there a property setting or something else that is
limiting this box to the first 16 values?

Thanks for all the input. While I was waiting for respones I changed
"something" in the bound column's properties, but I'm not sure what it was
that solved the problem. I was altering one or all of properties such as
"list rows", "limit to list", and something else.

Thanks anyways!

"Sprinks" wrote:

Nick,

I suspect that the Bound Column value in the last three records has a
duplicate value to one of the first sixteen. For example, consider the
following records as the row source of the combo box, selecting both columns,
with the first one bound:

ID Value
------------ ------------------------
1 Margie
2 Tom
3 Susie
4 John
4 Billy

Billy will not be able to be selected, because when chosen, ID = 4 is
written to the control. I'm not sure how Access processes this, but when I
test this, John is displayed after selecting Billy from the drop-down list.

This is a good reason to include the primary key from the table in any
RowSource, and use it as the BoundColumn.

Hope that helps.
Sprinks


"Nick" wrote:

I have a combo box that is based on a query that displays 19 records in the
query and all 19 values are displayed in the combo box's drop down list.
However, I can only select the first 16 values in the list to be returned to
the combo box. Is there a property setting or something else that is
limiting this box to the first 16 values?