Using List View Control on Access Forms

[Ibrahim Dashti]

Peace be upon you...
I'm trying to use the List View control in Access to get more
functionality that just a normal List Box. I know how to add the control
itself, and I found some material on how to manipulate the control in VB. I
think there's a way to manipulate this control in Access too, like adding
columns, adding items, etc. I checked the properties and methods available
for this control in Access and could not find anything that helps in taking
full advantage of this useful control in Access. Can anyone help? This is a
link about this control and what it can do, but in a VB environment:

http://msdn.microsoft.com/library/d...frlrfsystemwindowsformslistviewclasstopic.asp

There should be someway to do similar things in Access. Please help me.

 

[Douglas J Steele]

Essentially, anything you can do in VB, you can do in VBA with respect to
the ListView control. The problem is the link you gave is for VB.Net, not
for VB.

Take a look at the samples Randy Birch has in the Common Controls section of
his site http://vbnet.mvps.org/code/comctl/index.html (Yeah, I know: the
"vbnet" in the site name is misleading. Randy's been using the name far
longer than Microsoft has!) (Obligatory warning: The site is aimed at VB
developers. Since there are significant differences between the controls
available for forms in VB and Access, many of the samples won't port
directly into Access. In this case, though, since the ListView control comes
from a separate ActiveX control, you should be fine)