Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combo box record limit (a2k)

    I have a combo box with 73,000 records. Only the first 65,000 will display in the drop down. Is there a size limit to the combo box recordset? What's a good strategy for getting those last 8,000 records to display?

    E

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combo box record limit (a2k)

    A combo box can contain 2^16-1 = 65,535 elements, and there is no way around this limit, it is a technical restriction. But long before that, it will become virtually unusable. You should replace the one combo box by two or three cascading combo boxes, in which the user can successively narrow down the selection. Search this forum for cascading combo, or look at ACC2000: How to Synchronize Two Combo Boxes on a Form and ACC2000: How to Create Synchronized Combo Boxes.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box record limit (a2k)

    The combo box is a zip code lookup. Typing the zip pulls up the city, state and country in separate text boxes. The only time the multiple column display of the combo box is needed is when two cities have the same zip and the user needs to choose between the two. Is it possible/practical to create a command button to reverse the sort order of the combo box so that the 8000 records that don't display in ascending would in descending rather than creating a cascading combo boxes?

    E

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: combo box record limit (a2k)

    You can change the Row Source of the combo box in the On Click event procedure of the command button. Either prepare two queries, one that returns the zip codes in ascending order, and another that returns them in descending order, and set the Row Source to the name of the appropriate query, or set the Row Source to an SQL statement that returns the records in ascending or descending order.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: combo box record limit (a2k)

    works like a charm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •