MS Access - Combobox 2

[mas17]

I find that I cannot scroll down beyond 65000 records in an MS Access Combobox.

Q1. Is this a restriction in Access.

Q2. Can anyone suggest a way to overcome this restriction. The combobox gets its values from a single table (155000 entries)

Many thanks

Mas17

 

[rafe]

Check out this Web page at MS. It MAY help

http://msdn.microsoft.com/library/techart/msdn_vlb.htm

A Virtual List Box Implementation with VLIST

 

[jendendav]

If you don't mind my asking, why would anyone scroll through 65,000 records looking for one specific entry? If I had to scroll through that much just to find one entry I'm afraid I would revolt and refuse to use the database but surely I'm just not grasping the application.

Thank you for the patience to answer.

 

[rafe]

just a wild guess... mas17 is likely using the autofill/autolocate feature to limit the scrolling to a smaller area of the huge list???