Results 1 to 6 of 6
  1. #1
    mp3909 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    154

    Horizontal Scroll Bar

    Is there a way to add a horizontal scroll bar for a list box?


    By default, I have a vertical one but need a horizontal one too as some of my text is quite long.

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158
    Access will automatically add one if your column widths add up to more than the list box width.
    But not if you first column is set to 0 width !

    If you need it hidden (frequently a requirement) set it 0.1 or something equally tiny.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    mp3909 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    154
    Hi Minty,

    I still don't get a horizontal scroll bar in my first list box which is only made up of 1 column. The column width is 2.54cm so I should see a scroll bar going along horizontally, no?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	10 
Size:	74.2 KB 
ID:	37944

    See the highlighted entries in the image below are getting cut off and there is no way to see what the latter part of their names are

    Click image for larger version. 

Name:	Capture.PNG 
Views:	10 
Size:	37.9 KB 
ID:	37945

  4. #4
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,158
    It has to be multi column - It assumes if you only have one that you make the list wide enough.

    Add a blank column and set it's width to 0.01, then your scroll bar will appear.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    mp3909 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    154
    Quote Originally Posted by Minty View Post
    It has to be multi column - It assumes if you only have one that you make the list wide enough.

    Add a blank column and set it's width to 0.01, then your scroll bar will appear.
    When you say set the width to 0.01, do you mean the width for column 2?
    I am not sure if it is possible to set the width of individual columns in a list box, or is it?

    The Width I see in this property box, how do I know if it is for column 1 or column 2?

    Click image for larger version. 

Name:	Capture.PNG 
Views:	9 
Size:	18.9 KB 
ID:	37946

  6. #6
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Use 0.01 or similar for your extra 'dummy' column 2
    You need something like 8cm;0.01cm with a semicolon between the values. Anything that adds up to more than the listbox width of 7.302cm
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 2
    Last Post: 07-26-2016, 02:52 PM
  2. horizontal scroll bar
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 05-28-2015, 08:03 AM
  3. Replies: 2
    Last Post: 10-01-2014, 09:10 PM
  4. Replies: 13
    Last Post: 07-19-2013, 08:34 AM
  5. Control of horizontal scroll bar
    By smthomer in forum Programming
    Replies: 3
    Last Post: 08-25-2010, 10:52 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