Results 1 to 4 of 4
  1. #1
    KristenS is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2

    Exclamation Adding 354 items to the list in a combo box.

    Hello!

    I'm attempting to add 354 items to a list in a combo box on a form. However, Access keeps cutting my list off automatically at 70. This combo box holds a list of institutions to choose from when collecting data. Can anyone help?

    Thanks,
    KristenS

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Are you trying to set up the combo box using "Value List" as the "Row Source Type"?

    With that many options I would use a table.......

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    As Steve suggested...we really need to know what kind of RowSource Type we're dealing with, here, and, I should think, exactly how you're populating the Combobox. Without knowing these things, we'd just be spinning our wheels, trying to help you.

    And if you are, indeed, using a 'Value List,' rather than a Table/Query, as your RowSource, Steve's advice about using a Table as the source is dead-on. With that many items, and a list that is likely to change, over time, a Table/Query is the only approach to take.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    KristenS is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    2
    Yes, my row source was value list instead of table. I will change that and see if it works.

    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-21-2016, 09:46 PM
  2. Replies: 21
    Last Post: 10-19-2015, 05:38 PM
  3. combo-box list items edit form
    By raffi in forum Forms
    Replies: 3
    Last Post: 10-26-2014, 03:22 PM
  4. Replies: 9
    Last Post: 09-09-2013, 03:56 AM
  5. Replies: 2
    Last Post: 05-31-2013, 03:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums