combo box number of entries limits

[drabbacs]

I know this has been asked and answered in previous posts
but I do not remember where. How can one list more entries
in a combobox than the 1100(?) that Access allows?

Thanks,
Drabbacs

 

[Dirk Goldgar]

I know this has been asked and answered in previous posts
but I do not remember where. How can one list more entries
in a combobox than the 1100(?) that Access allows?

Access combo boxes can have up to 65535 (or 65536) entries. If you want
more items than this to be listed, you're out of luck. Even this many,
though, is way too many for a worthwhile user-interface element. So you
should probably do something to limit the number of items in the list,
such as having the user enter the first few characters of the desired
entry in a text box, and then setting the combo box's rowsource to a
query that returns only the items that match those characters.