highlight keywords in search results in report

[lala]

Hey guys
it's been a long time since i've been here
but i again need your help

my job asked me if it's possible to have keywords highlighted in search results in report
am i clear?
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 in Word, or in searches on the Internet, 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?

 

[llkhoutx]

Probably, depending on your report. You don't give enough information (for me) regarding your report.

 

[lala]

what do you need to know?
I have a report with the results of the search, and i need the search keywords to be highlighted

 

[llkhoutx]

If the report results are in individual fields in dividual rows, you can use the Condiftional Format property for each field usinf the row key in the condition.

If the "keywords" are in the middle of a text string, you'll have to concantenate the strings portion before and after the keywords, multiple times if multiple keywords are in one string.

Aalternatively, FMS has a rft memo field generator which lets one do what yu want.

 

[lala]

OK, now I understand what information I should give
the field that I'm searching is a memo field with people's resumes in text format
so if a user is searching for the word Unix, he gets all people that have Unix in their resume but the field is so big, that it's hard to see where the word is

so how can the word Unix be highlighted each time it repeats in that resume memo field

clear?)))))))))))))))
thank you for taking the time out

 

[llkhoutx]

Access can't/won't highlite within a field.

The FMS tool to mention before does that exact thing.

 

[lala]

that's what I thought, that it won't

but now you're confusing me, you just said that it won't do it, but now saying that the above mentioned FMS tool will

how is that?
and if that's the case, then where can i get it? and how does it work?

 

[llkhoutx]

They charge money for there tool. My advice is free.

There numerous tools are described here.

 

[lala]

I know your advice is free, but you just finished telling me that Access can't do taht

so can it or not?

 

[lala]

I need this now more than ever

i'll even pay for a tool


also, how come I can't use scroll down inside a memo fiels, when i scroll, all text just disappears

so any ideas for highlighting the keywords? and also, scrolling?

thank you very much

 

[yammoo]

regarding above link

after sending the post with the link in it, i forgot to mention that these dbs were for access 97 and 2K. i know wen i had 2003 of access, i couldnt access those type of files. so if any one needs the code really desperately then i'll happily post the code online and u can tweak it to ur version of access. please keep in mind that other people might enjoy this edit as well. i would do it myself, but i wouldnt even know where to begin wen it comes to that type of tweaks. <shrugs>

sorry goes to lala especially!

woah looks like the admin removed my prior posts.....dunno y because there was no viruses or anything of that sort. at least not that i know of.......<gulp> good luck!

 

[yammoo]

actual link......same one as other post thread

www.lebans.com/*mixbold-plain.htm -- access 2000 and 97 db sample that searches for keywords via a memo field and highlights them i.e. changes their color when a report is displayed. enjoy! and sorry again bout the mix-up.......

good luck

oh and please change to version 2003 if u can....post for others who can't or dont have time.

oh and last thing, if can't get it and in real dire need of it, then let me know via this post thread and ill copy and paste it from the 2000 version.