Results 1 to 4 of 4
  1. #1
    MWF is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    4

    ComboBox with Column Count 2, not showing both columns, you have to scroll to see 2nd column

    I have a Table called 'TableA'. It has a column called 'ColumnA'. I set up ColumnA to be a ComboBox who's Row Source is a query of another table selecting two columns called 'Column1' and 'Column2'. The Bound Column is 1 (Column1) and the Column Count is 2. Column Widths are 20cm;55cm. List Widths is 10cm.



    When I open TableA in Datasheet view, and click in ColumnA and click on the arrow to launch the ComboBox, only Column1 displays. To view Column2 I need to use the scroll bar at which time only column Column2 is visible and I need to scroll back to see column Column1. Adjusting the Column Widths or the List Width does not solve it.

    How do I set-up ColumnA so I can view multiple columns in its combobox? I'm assuming its a Field Property in the Lookup tab of Design View of ColumnA. I know its possible because I have another database with a table and column that does this. I compared the Design View Lookup values and they are the same, yet I have this display problem.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Perhaps I'm missing something, but 20+55 = 75, but you've set the list width at 10. Try 75.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    MWF is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    4
    Quote Originally Posted by pbaldy View Post
    Perhaps I'm missing something, but 20+55 = 75, but you've set the list width at 10. Try 75.
    Thanks! 57cm seems to be the max List Width. My problem was I had the column widths set to high so I was only seeing one column regardless of what List Width I tried. I have made my Column Widths smaller and I can now see both columns. Thanks again.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site! I couldn't think offhand how wide that was in cm.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 01-16-2015, 09:28 AM
  2. Replies: 5
    Last Post: 11-02-2014, 11:05 PM
  3. Replies: 1
    Last Post: 11-12-2013, 02:19 AM
  4. Replies: 1
    Last Post: 12-09-2011, 05:02 PM
  5. combining 3 columns into 1 new column!
    By joebox8 in forum Queries
    Replies: 7
    Last Post: 07-06-2011, 01:46 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