Results 1 to 5 of 5
  1. #1
    Reviewer is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    8

    Can I list box be made to display a couple columns of data rather than a scrolling list?

    I have a list box with quite a few options on it and want to display it on the form all at once rather than having to scroll through the list. Is there a way to do this? I have made the columns in the box but the text only fills in one column. The other two columns stay blank and I still have to scroll to see all the options.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Have you set listbox properties:

    ColumnCount
    ColumnWidths

    Post the listbox RowSource sql statement.

    Is the listbox sized large enough to display all rows?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Reviewer is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    8
    I did change the ColumnCount and ColumnWidths. It should be plenty big to display the options. The first column has the subcategories to select and the second and third columns are blank.

    I have no idea how to post the RowSource sql statement.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If the RowSource property has an SQL statement, just copy/paste the statement. If the RowSource references a query object, open that query object in SQL View and copy/paste the statement.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Reviewer is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    8
    I am such a newbie that I don't know what you are talking about doing let alone how to do it.
    Click image for larger version. 

Name:	scrn shot list box.png 
Views:	8 
Size:	17.3 KB 
ID:	21787

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

Similar Threads

  1. Replies: 2
    Last Post: 07-03-2013, 08:14 AM
  2. Replies: 3
    Last Post: 02-12-2013, 11:26 AM
  3. Replies: 2
    Last Post: 04-05-2012, 08:39 PM
  4. Replies: 1
    Last Post: 11-29-2011, 11:17 AM
  5. Input data from one list box to another list box
    By KellyR in forum Programming
    Replies: 0
    Last Post: 06-04-2010, 11:24 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