add horizontal scroll bar to listbox

[Arianna]

I have a list box in Access 97, which is filled by a query. Some of the values are wider than the list box, but there is no horizontal scroll bar.

I tried to define the column width wider than the listbox width, but that doesn't help either.

A horizontal scrollbar appears only when there are more than one column, but even if I add a "dummy" column to get this scrollbar, it doesn't scroll the first column, only jumps to the second column, so there is no way to view the first and meaningful column in full.

In the net I found some soultions for Visual Basic forms, where they add a horizontal scroll bar with the API function SendMessageByNum, but this doesn't work with Access Forms because there is no hwnd property for listboxes in Access.

Any suggestions?

 

[llkhoutx]

My experience is that when sum of the width of the various columns (property "column widths") in the list box exceeds the width of the list box (property "width"), a horizontal scroll bar appears.