Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2014
    Posts
    18

    Unanswered: Combo Box Problem

    Hi all! I have a question.

    I have a database with a form I am working on. On the form I put a combo box that I can use to choose a Law Enforcement agency, then the law enforcement agencies' information would auto populate (address, city, zip, etc.).

    Well, this morning I opened up my database that I am working on and made some changes to my form, tested everything out, and was happy with the results. Then I moved fields around (layout changes) and added some fields from another table. Then, when I went in to test my first combo box that I talked about in the first paragraph above, it has all of the information in the combo list selection so that now it just looks ugly when selecting it. Whereas before, it showed JUST the agency name, and it auto populated the rest into the fields. You can see what I mean in the screen shot below in the attachment.

    Why is it doing this all of a sudden? Literally, it was working half an hour ago with JUST the agency name. Now, it shows everything in there and I didn't even change anything!!!

    Thanks in advance!

    ~Access Newb~
    Attached Thumbnails Attached Thumbnails Screen Shot Access Forums.png  
    Last edited by AccessNewb; 05-08-14 at 14:58.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Use the ColumnCount and ColumnWidth properties of the combo to mask/unmask the columns in its list part.
    Have a nice day!

  3. #3
    Join Date
    Apr 2014
    Posts
    18
    Great, thanks guys, I think I got it fixed!

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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