|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 23rd, 2009, 09:53 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Keyword Search
I am using "Like" for a keyword search. is there a way to highlight or bold
the keyword whenever it appears in the results? -- Tendoy5 
|
|
#2
September 24th, 2009, 12:56 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Keyword Search
What version of Access are you using and where are your search results being
displayed? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tendoy5" wrote: I am using "Like" for a keyword search. is there a way to highlight or bold the keyword whenever it appears in the results? -- Tendoy5
|
|
#3
September 24th, 2009, 01:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Keyword Search
I am using Access 2007 and my results are being displayed in a report
-- Tendoy5 "Dorian" wrote: What version of Access are you using and where are your search results being displayed? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tendoy5" wrote: I am using "Like" for a keyword search. is there a way to highlight or bold the keyword whenever it appears in the results? -- Tendoy5
|
|
#4
September 24th, 2009, 05:51 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Keyword Search
Unfortunately, I don't have that version so am not familiar with any new
features it has. If you are displaying a bunch of text in a report control and want to bold just certain parts of the text, as far as I know, there is no way. You can only bold the contents of an entire control not parts of a control. What you could do is to have another control underneath that one and print something like asterisks underneath where the text is. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tendoy5" wrote: I am using Access 2007 and my results are being displayed in a report -- Tendoy5 "Dorian" wrote: What version of Access are you using and where are your search results being displayed? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "tendoy5" wrote: I am using "Like" for a keyword search. is there a way to highlight or bold the keyword whenever it appears in the results? -- Tendoy5
|
|
#5
September 24th, 2009, 08:41 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Keyword Search
I imagine it could be done with a rich text control and the replace function
if you were not looking for values with wild cards in the middle of the criteria. For example Like "*Abyss*" But not Like "*A[bcd]yss*" You would need to know the coding that is used in the rich text control to bold something. You can perhaps use something like Replace([MyTextField],"Abyss","bAbyss/b") I can't experiment with that right now. If the control you are using is just a text control you could use the technique to add some characters before and after to help spot the hits. Replace([MyTextField],"Abyss","/-/-/Abyss/-/-/") John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County tendoy5 wrote: I am using Access 2007 and my results are being displayed in a report
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
