Results 1 to 2 of 2
  1. #1
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101

    How to increase the number of columns in a drop-down list (combo box)

    I know that, using the combo box wizard you can create drop-down lists which have more than one columns.

    I have a combo box field in table1.


    While creating it, I had run the wizard and made it get its values from a table (e.g.table2) which had a single column only.
    Now, I've modified the table2 so that it has 2 columns.
    I'm not able to make the combo box display both these columns in the drop-down list.

    What I've tried so far (unsuccessfully though!):
    In the design view of table1, under lookup in field properties > Row source > ellipsis button
    Show > I ticked both the columns
    But still, only column 1 shows up in the drop-down list

    Is it possible to do this?

  2. #2
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101
    Got it!

    Just had to change the column count to 2 under the lookup tab.

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

Similar Threads

  1. OnClick increase number in field on form
    By DCV0204 in forum Forms
    Replies: 1
    Last Post: 07-25-2014, 11:02 AM
  2. Replies: 2
    Last Post: 04-13-2014, 06:55 PM
  3. Replies: 6
    Last Post: 01-28-2014, 11:44 AM
  4. Replies: 7
    Last Post: 10-26-2011, 01:47 PM
  5. Increase number by 1
    By elstiv in forum Queries
    Replies: 2
    Last Post: 05-14-2011, 12:25 AM

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