combo box number of entries limits

  • Thread starter Thread starter drabbacs
  • Start date Start date
D

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
 
drabbacs said:
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?
Click to expand...

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.
 
Back
Top