Combo box limit

[muppetmad]

I have a combo box that worked fine. Now it will not show any records after the 65530th record. I can remove a record and it will show the next one down so it appears to be a setting that controls the nuber of records shown. Any suggestions on how to show all the records would be great.

The program is attached to a SQL table.

 

[Rich]

You could limit the combo by breaking down the records into alphabetic or numeric groups