Is there a limit of items that can be listed in a Combo Box in Access 2007

[vhughesr]

My combo box presently has 100 lines and I want to add more. For example, the last line is supposed to be specialty and it stops at speci
is there an easy fix to this problem?

[NoellaG]

Hi,

do you use a value list or a query as row source? It could be a value list has a limited number of characters. However, using a query as row source, you should be able to have as much entrees as you wanted. However, I wouldn't recommend to use much more then 100 items in a list because it's getting slower and not so user friendly when you're using very large lists.

succes
NG