Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2004
    Location
    Wiltshire, UK
    Posts
    526
    Thanks
    1
    Thanked 45 Times in 43 Posts

    Limit on Combo Box columns ?

    I'm using Access 2003 and resurrecting my ancient skills on a simple database.

    I have a simple table and a query with 11 columns. I am selecting the key field with a Combo Box which picks up all the remaining columns from the query, then displays some of the results in text boxes. That's all fine except that I only seem to be able to pick up the first 8 columns, then the text boxes don't show anything when pointed at the relevant columns eg =Combo0.Column(9)

    Am I doing something wrong, or have I hit an Access limitation ? Either way, is there a better (simple) way of doing this ?

    Thanks
    Last edited by MartinM; 2014-03-15 at 20:25.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,496
    Thanks
    3
    Thanked 42 Times in 42 Posts
    In general combo boxes aren't used to that many columns, simply because you run out of horizontal space when all of them are displayed. So I presume you are hiding some or most of the columns. The first column in a combo box is referred to as Column(0), so Column(8) would actually be the 9th column. But I'm not aware of any limitation on the column number like you are apparently seeing.

    As an alternate way of doing what I presume you are doing, you bind the form that contains the combo box to the query you are using, and then use the combo box to select a specific record in the query, either with a filter or using a recordset approach. The latter is how the combo box wizard selects a specific record in a table, and in that case the combo box is unbound, and uses a small VBA procedure to display a specific record on the form.
    Wendell

  4. #3
    New Lounger
    Join Date
    Mar 2013
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post Check the property sheet

    Make sure you have defined 11 columns on the combo box property sheet. If you have defined fewer than 11, Access and the combo box will not see all of the query columns and you cannot address them. In your example, not being able to address Column(9) suggests that the number of defined columns in the combo box is less than 10.

    I'm guessing the actual limit is 255, but no one would ever go there, would they? <smile> The most I've ever used is in the neighborhood of 10.

Posting Permissions

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