Post code in cobo box not showing all records

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

Access 97

I have a combo box which is looking up Post Codes. The list is limited to
show 8 records and is in alphabetical order. When I start to enter the code
it stops at HP and then shows blank records.

Is there a way to extend this to cover all records. Total record 190,000

Thanks

Les
 
Is there a way to extend this to cover all records. Total record 190,000
Click to expand...

A Combo Box is limited to 65536 rows (far too many to be humanly
useful IMO <g>).

There are several "tricks" to prefilter the combo's RowSource - for
instance, you can use the Combo's Change event to filter to just the
ZIP codes starting with 0 or 1 or 2 on the first keystroke.
 
-----Original Message-----
Access 97

I have a combo box which is looking up Post Codes. The list is limited to
show 8 records and is in alphabetical order. When I start to enter the code
it stops at HP and then shows blank records.

Is there a way to extend this to cover all records. Total record 190,000

Thanks

Les
Click to expand...
Hi Les, a combobox (or listbox) struggles with this number
of items listed. Find a way to limit the number of items
to approx. 2,000 or less.

Luck
Jonathan
 
Back
Top