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

[Guest]

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?

 

[Allen Browne]

Theoretical limit is 64k, I believe.

Practical limit is just a few thousand.

You can delay-load the combo if you have more than that. Details:
http://allenbrowne.com/ser-32.html

 

[Guest]

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:

http://allenbrowne.com/ser-32.html

 

[Guest]

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

 

[Ken Snell \(MVP\)]

Theoretical limit is 64k, I believe.

65,536, to be "exact". Same limitation for a listbox.