horizontal scrolling of a column title with the control

[jjd100]

I have a situation where I had a listbox which displays the results of a query. I created some labels above it in the form to describe the contents. Life was good.

The listbox is now wider than the screen, and I now scroll it horizontally, alas the labels are stationary.

What is the best way to have "column headings" which may be 3 or 4 rows high that would scroll horizontally with the listbox?

 

[ZOR]

I think you are unable to play with the column heading sizes on a listbox. I was trying to do a similar thing a while back, but my listbox was taller than the form. In the end I looked around at grids and found a grid which did the job, although I never bought it as the project died. While waiting for other answers to flood in, have a look at

http://www.download.com/SCGrid/3640-2403-8479339.html

If you click on the publishers name you will see the manufacturers page where there is reference to its use with Access. Hope you find it of interest. Regards

 

[PHV]

Have you tried to play with the ColumnHeads property of the ListBox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886