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 :) )