Horizontal Scroll bar on a combo box

[aronmcdermott via AccessMonster.com]

I've researched and tried all the suggestions I've found and still haven't
been able to get the horizontal scroll bar to appear in my combo box. I've
tried setting the Column Widths property larger than the Width property and
set the List Width property to Auto as someone suggested in another thread
but it doesn't work. I give up. Please help. If more info is needed let me
know.


The rowsource is a simple query:
SELECT ANSWER_TEXT
FROM COMPLAINTS_DATA
WHERE QUESTION='Please select complaint category';

Thank you in advance.

 

[Ron2006]

I am able to get the horizontal scroll bar IF
the "List Width" is less than the sum of all the individual widths of
the fields I am showing.

 

[aronmcdermott via AccessMonster.com]

I am able to get the horizontal scroll bar IF
the "List Width" is less than the sum of all the individual widths of
the fields I am showing.

Thanks for the reply Ron. I've tried setting the "List Width" field to auto,
and to 1". I can't get anything to work. I'm not sure I understand what you
mean by the "sum of all the individual widths of the fields I am showing".

 

[Douglas J Steele]

Assume you've got 3 columns with the first one set to 0", the second one set
to 1" and the third one set to 3". ListWidth would have to be less than 4 to
get the scroll bar.

 

[aronmcdermott via AccessMonster.com]

I only have one column. Is it not possible to get the horizontal scroll bar
with only one column?

Assume you've got 3 columns with the first one set to 0", the second one set
to 1" and the third one set to 3". ListWidth would have to be less than 4 to
get the scroll bar.
[quoted text clipped - 3 lines]

and to 1". I can't get anything to work. I'm not sure I understand what you
mean by the "sum of all the individual widths of the fields I am showing".

 

[Ron2006]

hmmmm.....

When I had only one column it seems like list width was the controlling
factor and no matter what I did I couldn't get it to show any scroll
bars. However I could make it as big as I wanted and Access would
adjust its left side so that the entire width fit on the screen.

It seems as if I have to have at least 2 visible columns for the scroll
bar to show.

Ron

Doug, did you find any other solution?

 

[aronmcdermott via AccessMonster.com]

Thanks for the help guys. If anyone has a solution that would be great but
as Ron stated by adjusting the List Width you can expand the viewable area
horizontally. Maybe that's the only way when using only 1 column.

Thanks guys.

 

[Rick Brandt]

Thanks for the help guys. If anyone has a solution that would be
great but as Ron stated by adjusting the List Width you can expand
the viewable area horizontally. Maybe that's the only way when using
only 1 column.

The horizontal scrollbar is for scrolling *columns* not the *content within
columns* so yes, by definition if you only have one column then a scrollbar
will never show.