Access 2010 List Box Horizontal Scroll - revisited

I'm using Access 2010 and have a form with 5 cascading list boxes. The cascade works great.  The list boxes source are queries done on the fly.
The problem is that the list boxes are not wide enough for the data. I have two columns of data. The first column is a description, the second column is a numeric (key) value that I had hidden. The list box is in Extended mode.

The solution that I have seen time and time again is:
1) If the list box width is > than the width of the item, there should be a scroll bar if the widths are set to a non-zero.
The width of the list boxis 1.9167. The column widths are currently set to 4";1". The bound column is 2
This gives me a scroll bar, however, it only scrolls to the second field, it bypasses the remainder of the text!

Perhaps I havent got some configuration set up correctly.

I've tried looking up placing the value in a tool tip, but that's a bit difficult without the user actually selecting anything - mouse move is great, but I dont know what the user is on top of with the mouse.

Any ideas on why the scroll would not scroll the length of the text in the first column?
(I've tried upping the length in the width box to 20" to no avail :) )
GNOVAKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
<The problem is that the list boxes are not wide enough for the data.>
Then why not make them wider? (the form max width is 22 inches...)

Or change the layout of these listboxes to be vertical if they are horizontal...

I am having difficulty visualizing this issue with no context (a sample file or screenshots)

<The width of the list box is 1.9167. The column widths are currently set to 4";1". The bound column is 2>
I am not understanding these settings...?
If the listbox is 2 inches wide, then why is the first columns set to 4" and the second set to 1" (5 inches total)
Why not just set the listbox to 5 inches wide?
0
Jeffrey CoachmanMIS LiasonCommented:
<1) If the list box width is > than the width of the item, there should be a scroll bar if the widths are set to a non-zero.>
Again, I am not understanding this...

How are you determining "If the list box width is > than the width of the item"?

Can you post a simple sample database with perhaps two listboxes, that demonstrate this issues...

Or perhaps another Expert can see what I am missing (or not understanding) here...

JeffCoachman
0
GNOVAKAuthor Commented:
There are 5 list boxes next to each other. Each box to the right breaks down the selection a bit more. Think of it like this:
1st list box: Cars, Trucks, Boats, Planes
2nd list box: if cars are selected, it shows Audi, Dodge, Lexus, etc
3rd list box: models.... etc

I would love to just make them longer, but the screen realestate wont allow for it.
They have to be horizontally aligned.

Also, the query is based off of linked tables. The column width of the field is large enough to support the entire name and it is shown in the query, once the column width is adjusted.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

GNOVAKAuthor Commented:
I added to the confusion, sorry.  I meant to say
If the list box width is LESS than the length of the column width (& the item text).
0
Jeffrey CoachmanMIS LiasonCommented:
<There are 5 list boxes next to each other.>
Then as I stated, ..then why not stack them "vertically",  where each lisbox could have as much as 22 inches in width...

< I meant to say
If the list box width is LESS than the length of the column width (& the item text). >

Still confused, ...why would you make the list box width is LESS than the length of the column width ?
If the columns widths total 5 inches then why not just make the listbox 5 inches wide?

Again, without any context, this is difficult to visualize...
0
Nick67Commented:
The width of the list box is 1.9167. The column widths are currently set to 4";1". The bound column is 2

A listbox is only going to show you the width of the control -- no more. no less
There isn't any point to specifying any column width bigger than 1.9167
You won't see anything larger.
No, your scrollbar isn't meant to help you with that.
Your scrollbar allows you to scroll the 5" width (4" + 1") that you've specified for the columns.
But it won't do anything about the divisions within the scrolling -- YOU'VE specified those to be 4" and 1"

To see anything larger than the control, you'll need a combobox and not a listbox
Initial sample attached
bars.mdb
0
Nick67Commented:
Comboboxes have a ListWidth property that lets you display a wider field than the control when dropped down -- but listboxes lack that
bars.mdb
0
GNOVAKAuthor Commented:
Nick67 -
Exactly!
That's the problem.  The user can multi-select from the list boxes.
But the text goes beyond the width of the box.  I can not increase the size of the list boxes because of the size of the form - same as in your example if the form size was already maxed.
If I was to stack them, the user would be unable to see all the selections at once and it seems it would appear "sloppy". If I could layer them somehow, expanding box1 would hide box2 and that wouldnt help the user.

Remembering that the list boxes are Extended for multi-select, perhaps there is another way to get the "last selected" item and display it in a text box or some other type of control.
Using a combo box for this might be confusing to the user that is accustom to using a CBO as a selection.

Any ideas on how to present?
0
Nick67Commented:
How's about a popup form with a single -- VERY WIDE -- listbox on it that pushes the changes back to the original form

Like in the sample :)
bars.mdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GNOVAKAuthor Commented:
Thanks so uch - worked great and I can make it work. never thought of that.
Straight forward as well.
0
Nick67Commented:
Yeah,

It is a good technique to have in your toolbox for those occasions when you've got controls that are going to be too big to fit nicely on a form, but do not, or cannot justify a full-blown form of their own
:)

Nick67
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.