65000 Row limit

  • Thread starter Thread starter NH
  • Start date Start date
N

NH

I know it's not strictly an Access question, but does
anyone know why there is a 65000 row limit in combo boxes?

I have noticed that 65000 seems to be a standard cut-off
in various applications including Excel, Crystal Reports,
Fox Pro.

I was wondering what the underlying reason was for all of
them to pick 65000..

Thanks

NH
 
Good morning,
I often use Combo Boxes that have sources refreshed after a prior combo box value has been selected. This limits my users' (and my) ability to keep within certain restrictions:

CB1 lists my distribution centers, but only those I have entered aisle ranges for) 19 or less.
CB2 lists the departments IN the distribution centers (based on CB1's value) that I have entered aisle ranges for.
Once I select the department, I have (generally) 2 - 3 choices in the CB3 (start of aisle), and then the same # of choices for CB4 ,the end of the aisle or area.

So, I see CBs as a restrictor (especially if I cannot 'add to list' on the values) and (personally) feel that if you want 65536 (2^16) choices, it might be more effective to change the control to a text box.

I'm sure there's a good reason to use a CB of that magnitude, but for my business, I cannot see what it would be. (yes, I'd love to find out!)

Thank you!
Derek
 
Back
Top