Listbox vertical scroll bar not useable

[Terri58ds]

On a multiselect listbox I cannot use the up, down arrows or drag the vertical scroll bar on the right hand side. What properties should I look at? (Access 2003)

The listbox functions perfectly other than this problem. I can select/multiselect the records but to move down the list (150 employees) I either have to use the mouse wheel or select a record and drag down in the box (thereby highlighting all the records) 'til I get to the bottom. Then I can select the record I'm after. Obviously this is counter productive to having a multiselect as the records at the top selections get unselected.

Thanks in advance,

 

[CyberLynx]

The ListBox in Access does tend to do some strange things but more so when the Horizontal Scroll Bar is in play as well.

I have also come across this problem before and found that if the list box is widened to accommodate the longest row displayed within it,the problem tends to float away.

.

 

[Terri58ds]

Thanks for the suggestion which put me on the right track.
The listbox was wide enough, I didn't have a horizontal scrollbar and had plenty of space on the right after column 5, but you clued me in to investigating the column widths. After goofing around a bit I got it fixed. THANKS!

What I found was the problem was the EmployeeID column was set at 0.5cm. I intended to set it to zero to hide it when the form is complete, but wanted to see it peeping out for my reference while programming. As soon as I set it wide enough the scroll bar worked perfectly.

I also found that I had to save the form, close it then reopen it to properly see that it worked. If I just switched between design view and form view and saved the changes it didn't always take.

On another form I set the column headings visible and found that if the column heading got cut off, even though the data all showed, it presented the same scrollbar problem. Column heading was tblEmployee.EmpID and values were 55 etc.

Brownie points for CyberLynx.