Strange behaviour of combobox

[odrap]

In the form frmOrders of my database i have a combobox where i can choose a ClientID and the dropdown list shows me all the clients in upgoing order with their related orders in descent order.
But the dropdownlist doesn't show all available clients. The two hundred heighest clientnumbers aren shown. However if i type one of these clientnumbers in the textbox of the combobox, the client is found.
If i go to the property sheet of the combobox and activate the query that serves as the recordsource of the combobox, all clients are shown!!!
I control of the records of these clients in the table Orders, doesn't show any difference with all the other records.
What can be the reason for these behaviour. Is it a question of a limit of records that can be shown via a combobox?

 

[AlexHedley]

Is there a number in the ListRows Property?
Does the combo show a scroll bar?

Suggestions:
Try changing the default value for Default Max Records in the Advanced tab of the Options window.

Options->Edit/Find
Check for a Limit.

Try a Compact and Repair.

Try creating a new combobox in case for some unknown reason Access has stored a Filter in it somehow.

 

[odrap]

Thanks for the help: I will give them a try

 

[odrap]

All the possibilities that you suggested doesn't fix the problem.
By mean of test, i removed the orders for the years 2009 and 2010 out of the order- and orderdetail table. With this reduction, the orders i missed are now visible in the dropdownlist. For me that means that there exists a limit for what about the number of records that a combobox can show in the dropdownlist, even with scrolling to the end of the dropdownlist. It must be said that even if the records couldn't be shown in the dropdownlist, the combobox can find them when the number is typed in the textbox of the combobox
I wonder why The team of Access doens't mention anything about this limit!

 

[Galaxiom]

Combos are limited to 64K rows. Like most limits in Access, getting anywhere near them usually means the design needs to be improved.