Is this even possible, would be cool if you could do this in acces

  • Thread starter Thread starter BrianPaul
  • Start date Start date
B

BrianPaul

I have a query that I search for a word, or words using this statement in the
query.

Like "*" & [Type anything you wish to search] & "*"

It works, But it there a way access can hightlight the word in the record
that it found.

Thanks,
 
You can do this in Access 2007. See:
Highlight matches - Matching characters of search results
highlighted in text box
at:
http://allenbrowne.com/AppSearchHighlight.html

The article contains a (free) downloadable sample database so you can see
how it works.

It takes advantage of the new rich-text text box in A2007 to highlight the
matching text.
 
Thanks, Will Check it out. I loaded Access 2007 but everything is in
different places.

Allen Browne said:
You can do this in Access 2007. See:
Highlight matches - Matching characters of search results
highlighted in text box
at:
http://allenbrowne.com/AppSearchHighlight.html

The article contains a (free) downloadable sample database so you can see
how it works.

It takes advantage of the new rich-text text box in A2007 to highlight the
matching text.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

BrianPaul said:
I have a query that I search for a word, or words using this statement in
the
query.

Like "*" & [Type anything you wish to search] & "*"

It works, But it there a way access can hightlight the word in the record
that it found.

Thanks,
Click to expand...
Click to expand...
 
Yes: it's quite different.

This may help you adapt to the current version:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

BrianPaul said:
Thanks, Will Check it out. I loaded Access 2007 but everything is in
different places.

Allen Browne said:
You can do this in Access 2007. See:
Highlight matches - Matching characters of search results
highlighted in text box
at:
http://allenbrowne.com/AppSearchHighlight.html

The article contains a (free) downloadable sample database so you can see
how it works.

It takes advantage of the new rich-text text box in A2007 to highlight
the
matching text.

BrianPaul said:
I have a query that I search for a word, or words using this statement
in
the
query.

Like "*" & [Type anything you wish to search] & "*"

It works, But it there a way access can hightlight the word in the
record
that it found.

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top