Max number of entries in a drop-down list

[Accessfm]

Hello,

A control on a form is a drop-down list.
That list will be populated from records in a table.

My understanding is that Access does not like it if a drop-down list has more than 100 or so entries.
However, the table will contain 10,000 or so records...any suggestions (or is the 100 or so limit not true)?

Best regards

 

[Ranman256]

NOT to put it in the combo list.
the datasheet record selectors will tell you this.
or Dcount()

 

[plog]

At some point there is a practical limit for human use. Ever fill out a web form that required you select your Country? Those things get to be like 200 entries long and god forbid you live in Mexico--it falls not quite in the middle of that huge list--good luck trying to scroll quickly to it. A good input should take less than a second to fill out--a huge drop down like that takes at least 5 to select the right entry.

So, it sounds like a drop down isn't the best choice for your input. I would instead choose a regular text input. Let user's type in their data and if it needs to be validated against a list, do so after they move off of the control--if its invalid display a message and tell them where they can get a list of valid inputs.