Combo Boxes/List Boxes Limited to 65536 (64 KB) Rows

[Kelly]

For some reason Microsoft decided to limit combo boxes
and list boxes which severely limits my search
functionality if it wont return more record.

I understand this to exist in Access 97 and 2000.

Does anyone know if this problem still exists in later
versions of Access?

If it doesn't then I will have to upgrade.

Thanks
Kelly

 

[Rick Brandt]

For some reason Microsoft decided to limit combo boxes
and list boxes which severely limits my search
functionality if it wont return more record.

I understand this to exist in Access 97 and 2000.

Does anyone know if this problem still exists in later
versions of Access?

If it doesn't then I will have to upgrade.

AFAIK it is still the same. People don't usually like scrolling through huge
lists anyway. A common method is to provide a TextBox where the user provides a
few starting characters so that the displayed list can be narrowed
significantly.




--
*******************************
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
*******************************

 

[Douglas J. Steele]

AFAIK it is still the same. People don't usually like scrolling through huge
lists anyway. A common method is to provide a TextBox where the user provides a
few starting characters so that the displayed list can be narrowed
significantly.

In addition to Rick's comments, take a look at what Allen Browne has at
http://users.bigpond.net.au/abrowne1/ser-32.html