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.
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.
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 ↓↓
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?
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
![]()
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 ↓↓
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