asked on

list view finditem

I am trying to program a find function that will locate the matching record (partial or whole word) in the list view.
Eg. Looking for "auto", I have tried the following:

Set itmFound = ListView.FindItem("auto", lvwText, , lvwPartial)
Set itmFound = ListView.FindItem("auto", lvwSubItem, , lvwPartial)

The above will work for matching of full word only. Please advise how to achieve the find function. Thanks.

terencebeh

ASKER

By the way, I need to search all the columns in the listview not just the first column.

bin_huwairib

terencebeh,

Try the following:

Set itmFound = ListView.FindItem("auto", lvwText, lvwPartial)
Set itmFound = ListView.FindItem("auto", lvwSubItem, lvwPartial)

I just removed the coma before lvwPartial.

Best regards
Bin Huwairib

bin_huwairib

Please reject my answer because it was posted by mestake.

MarkO

I have some code for you as soon as the previous answer is rejected.

LSILes

I haven't really thought out how to used it, BUT you could use the InStr fuction. The syntax is as follows:

InStr([start, ]string1, string2[, compare])

Just check out your VB Help. It's all in there. Good function! I love it. =) Hope it helps.

---LSILes
les@livingscriptures.com

MarkO

Still want to send your some code that will do this for you.

ASKER CERTIFIED SOLUTION

MarkO

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

terencebeh

ASKER

Hi MarkO,
How do I found out whether there is a matching found ? I tried
If item = Nothing then
...

but VB does not accept this statement.

MarkO

The Correct use of Nothing is:

If Item is Nothing then ... (not =)

or if not logic is prefered:

If not Item is Nothing then ...

The above statement would work fine.

MarkO