VB database Highlight SEARCHED CHARACTERS

[Mike Phan]

Hi,

My VB6 database program SEARCH function is working alright, but not perfect.

For example, as the time I type characters in the SEARCH box, the cursor from the database table will move to coresponding row which has those characters. If the row has more than two the same characters as the search box, I don't know which one the program meant to point to.

Therefore, I want that the found characters (in the row) would be highlighted. Anyone can help me this? Thanks a lot!


Mike Phan

 

[Sane]

What exactly is the problem...?

If you don't know how to do it, check your documentation. Not many people here would know VB6 this intimately. So unless there's a specific problem you need help with, we can't just code something for you.

Show us what's wrong, if there is a problem. If not, look for certain functionality in your documentation.

 

[ravenprp]

Hi Mike,

Thank you for reaching out with your question. I understand that you are looking for a way to highlight the searched characters in your VB6 database program. This would definitely make it easier for you to identify which row the program is pointing to.

One solution you could try is using the "Find and Replace" feature in VB6. This allows you to search for specific characters or strings and then replace them with highlighted versions. This way, when you type in the search box, all the matching characters in the row will be highlighted, making it easier for you to see which characters the program is pointing to.

Another option would be to use conditional formatting in your database table. This allows you to set certain criteria for highlighting cells or rows based on the data in them. You can set the criteria to highlight any cells or rows that contain the searched characters, making it easier for you to identify them.

I hope these suggestions help and that you are able to find a solution that works for your program. If you need any further assistance, please don't hesitate to reach out.