Highlight search keywords in report

[lala]

Hey guys

my job asked me if it's possible to have keywords highlighted in search results in report

meaning, when you search for keywords in one of the fields, and then your results come out in the report, can they be selected?

Like when doing a search on Monster, all your keywords will come out in red, that way you can easily read the results

so can this be done in Acess?

My search field is a memo field, and it contains peoples resumes in text format
so when i get my results, it's very hard to find those words in all that plain text

am I clear?

Thank you very much!!!
You guys helped me so many times here

 

[Moniker]

You can't do that in a standard memo field as applying any sort of formatting applies it to the whole field, not just part of the field. You would need to use the Microsoft Rich Textbox Control, which allows character level formatting. Unfortunately, it is still a textbox control, meaning you are limited in its size. The "Rich Memo Control" is third-party.

 

[lala]

thank you very much
do you know where I can get it and how much it is
and will it highlight my searches?
what I mean is, I have search reports, where user inputs criteria and gets the results in reports
and I'd like the search keywords be highlighted in those reports (the filed being searched is a memo field)
so that third party program will do that?

 

[Moniker]

You can do it without the third party control -- the word itself just won't be highlighted. It's all programming (lookup the InStr function and then combine that with a Mid function and some simple math to find all the matches).

If you just need to have highlighting and such in the memo field, it's not cheap (at least on this thing I was describing). It's a complete custom control found here.

With that price though, you can just use the aforementioned InStr to find and select each one (selecting will "highlight" it, sort of), but you can't select the multiples, only one at a time.

 

[lala]

thank you
i'm getting this for my job, and if my boss decides to buy it, i will gladly send you a copy for all your help

i just wrote them a letter asking about highlighting keywords, because i didn't see that in the description
format text inside memo field - yes, it does that
but nothing about highlighting search keywords inside memo field

so i'll keep you posted

 

[yammoo]

have sample db of that- not sure how to get to u

i have recently come across ur thread and as i was readin it i recalled having that particular database sample on my home computer. just not sure if u have found ur solution as of yet. let me know asap.

oh fyi this is being applied to a memo field and it searches the query i believe and brings up the report with that word "highlighted" i.e. has color changed to a blue i believe.

 

[lala]

no, i haven't found a solution

you can either email it to me, or there's a paper clip icon right next to the smiley face and the fonts, when you post the reply
if you press that paper clip, you can upload it here and everyone will be able to get it as well

you see it?
let me know if you will upload it, if not, i'll give you my email

thanks a lot!!!

 

[yammoo]

uploaded possible solution

oh n btw, i found this db sample kinna buried on the net. hopefully u can use it. turns out it wasnt on my home computer, but luckily as i said i found it on the internet. Enjoy!

Here is the link!
http://www.lebans.com/mixbold-plain.htm

 

[yammoo]

oops

sorry espec goes out to lala.......n every1 who is using an updated version of access. anyways, the above link is for 2000 and 97 versions of access. sorry forgot bout that minor detail until after i logged out. accidently posted this reply on lala's other post with the same question.

oh and if u do need to update please keep in mind the other people who dont have that ability or just plain dont have the time. i would do it myself, but not qualified to do that. and plus i wouldnt even know where to start. sorry.

good luck!