vertical scrollbar in listview control

[kenwarthen]

I have a listview control on an Access 2007 form that I'm trying to get the vertical scrollbar to display. In the control properties there horizontal scrollbar properties available, but nothing for the vertical scrollbar. Does anyone know how to get the control to display the vertical scrollbar?

Ken

 

[John Big Booty]

I'm not familiar with Access 07, but in earlier versions there was one property for scroll bar that could be set as Both, Vertical only, horizontal only or neither.

 

[kenwarthen]

That's true of the Access listbox, but the listview control is another issue, with hard to find documentation.

Ken

 

[missinglinq]

Actually, in Access 2003, scrollbars in ListBoxes are automatic, there is no property for Horizonta/Vetical/Both. They simply appear if the data requires them. Is the height of your listview control such that not all rows show? In most controls, as in Listboxes, scrollbars only appear if needed to allow viewing of all data.

 

[kenwarthen]

The height of my listview control is such that in most cases not all of the displayed records can be viewed. Clicking within the listview control has no effect either. I'm sure there's some method somewhere or someone must have encountered this issue before. It's unfortunate that the listview and treeview controls are so poorly documented as they're really handy controls.

 

[kenwarthen]

I found that if the FlatScrollbar property of the listview control is deselected the vertical scrollbar will appear. I'm not sure why that is so, as it doesn't make a lot of sense, but without access to control documentation there's a lot of trial and error guesswork involved in using listview and treeview.

 

[missinglinq]

Glad you finally got it figured out, Ken! Yes, they are aggravating with the lack of documentation. Then there's the fact that all of their Properties don't show up in the Properties sheet; many are only visible/available thru the code window. And then there's the version compatibility issues... but I digress, as the Bishop said to the nun!

 

[mikey222]

hi im using 2007 as well and trying to input a vertical scroll bar to my search results....could you kindly provide the solution ? cheers

 

[kenwarthen]

On the General tab of the ListViewCtrl Properties I have the following settings that among other things provides a vertical scrollbar on my form.

MousePointer 0
View 3
Arrange 0
LabelEdit 0
BorderStyle 1
Appearance 0
OLEDragMode 0
OLEDropMode 0

The Checkboxes are enabled as follows:

HideColumnHeaders = False
HideSelection = True
LabelWrap = True
MultiSelect = False
Enabled = True
AllowColumnReorder = True
Checkboxes = True
FlatScrollbar = False
FullRowSelect = True
Gridlines = True
HotTracking = False
HoverSelection = False

I'm not suggesting that you need to use the same settings as my control, but the property change that made the vertical scrollbars appear for me was the FlatScrollbar setting. As soon as I changed it from True to False, the vertical scrollbar appeared.

Good luck,

Ken

 

[mikey222]

Sorry i'm a total novice on access i dont even know how to pull out the ListViewCtrl Properties from 2007 to configure those settings...Could you kindly help out? Thanks

 

[kenwarthen]

With your form in design view, right click on the ListView control. A pop-up menu will appear. Select Properties from the ListViewCtrl Object item. A multi-tabbed dialog box will appear. The properties I discussed in my earlier post are on the General tab.

Ken

 

[mikey222]

thanks for the reply i finally fixed it...appreciate