Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    I have a form with 6 combo box controls on it. 4 of the 6 allow the auto expand feature to work. The other two will not auto expand. After much checking, the only difference I find is that the two that don't work reference a table's key field as the output. Even if I type the number in completely, it comes back and says that the number is not in the list. However, if I use the pull down and select the same number everything works. Anybody got any ideas???

    Thanks!!!

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    Strange. Are you perhaps formatting the number in same way?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    How are you using the combobox? What kind of error message, if any, are you getting? What do you mean by "referencing a table's key field as the output"? Do you mean you're selecting a key field value from the list as the bound column, or do you mean the combo is bound to the key field?
    Charlotte

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    There is no formatting for this combo box, it's left blank.

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    Hi Charlotte,
    No error message at all. Both combos are bound to the key field for their table. The other four combos on the form that work are not bound the the key field. Any ideas?

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    Is this key field numeric, and if so, what type (long, floating, etc.). And do you have any formatting specified in the table.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    It is set for long integer in the table (Autonumber). In the form, I have tried setting the combo box property format to general number. That doesn't appear to make a difference either. Any other ideas?

  8. #8
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    The only thing I can suggest at this time is to delete the combo boxes that aren't working from your form, then place new combo boxes on the form. I don't understand why you are having this problem.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  9. #9
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    527
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    I think that I found the problem. For the two tables the combo boxes reference, I put the format property of the key field to general number (field length was Long Integer-Autonumber). Now the combo boxes autoexpand. I can't explain why this is so but it appears to work!

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Combo Box - AutoExpand/Limit to List (Access 2K SR2)

    Are these combos actually *bound* to the key fields or only populated with the keys? You can't just insert an autonumber key into an autonumber field, and if the combos are bound, then selecting a value changes the value of the underlying field.
    Charlotte

Posting Permissions

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