On Wed, 02 Jun 2010 06:45:30 -0700, Tom van Stiphout
wrote:

Sorry, I meant:
myList.AddItem(strFilename & ";" & strFilePath)

On Tue, 1 Jun 2010 09:31:01 -0700, StuJol
wrote:

Sure. It's very simple. Since you are looping over a folder tree I am
assuming you're adding rows one at a time. Set the RowSourceType to
"ValueList". Then call AddItem for each row:
myList.AddItem(strFilename, strFilePath)
This would add one filename and one full path.
Then you can hide the Path column by setting the ColumnWidths property
to "1;0"

-Tom.
Microsoft Access MVP


thaks for your comments tom,
there will only be one version of each document so i dont see it an issue,
can you explain how to get multiple columes and change the visibility??

"Tom van Stiphout" wrote:

On Tue, 1 Jun 2010 04:56:04 -0700, StuJol
wrote:

That doesn't seem a good idea: several versions of a document by the
same name can occur in the tree. If I only show "test.doc", how would
the user know what to select?
That said, listboxes can have multiple columns, including invisible
ones.

-Tom.
Microsoft Access MVP


this is a query relating to allen browns List files recursively contribution
via http://allenbrowne.com/ser-59.html

brilliant contribution, works really well. the only issue i have is the full
path and filename are displayed in the list box, so my list box needs to be
the size of the screen to view full path.

Is there a way to just get the listbox to display the filename to the user
but to also keep the filename and path hidden so that the double click
hyperlink still works to open the documents??
.