Combobox box maximum rows

[Robert]

Hello.

I have a form with a combobox on it for customers. According to the Access
help, the maximum number of rows you can show in a combobox is 255. But the
company expects to have more than 255 customers. How can I get around this
limit?

Robert

 

[Guest]

Good Morning Robert

What would they say about eithor using New combos in Zip Code or
Alphabetical list?

 

[Rick Brandt]

Hello.

I have a form with a combobox on it for customers. According to the
Access help, the maximum number of rows you can show in a combobox is
255. But the company expects to have more than 255 customers. How
can I get around this limit?

Robert

Unless this is a new limit in Access 2007 you are misreading the help file or
the help file is wrong.

There is a general consensus of "proper interface design" that ComboBoxes should
not expose very large lists because they tend to not perform very well, but
there is no 255 row limit. If there *is* a hard technical limit then I believe
it is actually 64,000 rows.

 

[Robert]

I got an error in the properties window when I tried to enter more than 255
for the List Rows property and I confirmed this limitation in the help. Did
I misunderstand? What, then, is the List Rows property for?

 

[Robert]

I got an error in the properties window when I tried to enter more than 255
for the List Rows property and I confirmed this limitation in the help. Did
I misunderstand? What, then, is the List Rows property for?

Thanks.
"

 

[Rick Brandt]

I got an error in the properties window when I tried to enter more
than 255 for the List Rows property and I confirmed this limitation
in the help. Did I misunderstand? What, then, is the List Rows
property for?

That property determines how many rows are *displayed* when the list is dropped
down. It has nothing to do with how many rows the list contains. You will get
a scrollbar to expose the rest.

 

[Douglas J. Steele]

If there *is* a hard technical limit then I believe it is actually 64,000
rows.

AFAIK, the limit is 65535 (or is it 65536?), the total number that can be
addressed by an unsigned integer (2 bytes).

 

[Robert]

Okay, got it.

That property determines how many rows are *displayed* when the list is
dropped down. It has nothing to do with how many rows the list contains.
You will get a scrollbar to expose the rest.