What is the maximum amount of items a combo box can hold?

P

Pablo

Im trying to use a combo box on an MS ACCESS 2003 form to limit what the user
can enter in a particular field.
My question is what is the maximum amount of data items a combo box can hold?
 
P

Pablo

Thanks Allen,

Strangely postcode validation was what i was looking into, I've previously
tried just using an input mask but inevitably some incorrect postcodes do
appear so anyway thankyou for your answer and ill have a look at your code.
Regards
Paul
 
D

Douglas J. Steele

Hopefully you've read the other answers in this thread, and you now know
that there is a limit of 65,536 (which is the maximum value of an unsigned
integer) <g>
 
R

ruralguy via AccessMonster.com

Let's rib Doug and don't tell him the "maximum value of an unsigned integer"
is only 65,535 <VBG>
Hopefully you've read the other answers in this thread, and you now know
that there is a limit of 65,536 (which is the maximum value of an unsigned
integer) said:
There is no limit that I know of. If you have a large number of items in
your list, you may want to visit this site:
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
 
D

Douglas J. Steele

Yes, but 0-65,535 is 65,536 values. So there! <g>

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


ruralguy via AccessMonster.com said:
Let's rib Doug and don't tell him the "maximum value of an unsigned
integer"
is only 65,535 <VBG>
Hopefully you've read the other answers in this thread, and you now know
that there is a limit of 65,536 (which is the maximum value of an unsigned
integer) said:
There is no limit that I know of. If you have a large number of items
in
your list, you may want to visit this site:
Click to expand...
[quoted text clipped - 6 lines]
My question is what is the maximum amount of data items a combo box can
hold?
Click to expand...
Click to expand...
Click to expand...
 
D

David W. Fenton

My question is what is the maximum amount of data items a combo
box can hold?
Click to expand...

The maximum is the same as the maximum number a human being can
process visually in a dropdown list. That is, I'd say it's somewhere
below 100. Anything more than that is bad UI design.
 
K

Ken Snell \(MVP\)

David W. Fenton said:
The maximum is the same as the maximum number a human being can
process visually in a dropdown list. That is, I'd say it's somewhere
below 100. Anything more than that is bad UI design.
Click to expand...

Not 100% of the time -- the autoexpand feature of a combo box makes it
feasible for some situations where users want to just type in part of an
entry and let the combo box finish it -- makes for very fast data entry.
Course, one could program a form to act this way, but using the built-in
combo box does have its positive attributes in this case.
 
Top