Bold search terms in Query result for report

[NewbieInCT]

I have a query and a subsequent report that searches my table. The Parameter is called [all] and I get a popup box to enter my search term.

Is there a way to have the Report bold, underline, change the color, etc of the found word? to take it a step further, is there a way to say if found alone, to bold and change to red, and if found within another word, to bold green and underline?

An example would be Tent. If I search for Tent: I would want it to Bold and Red when found tent, but bold, green and underline when it finds retention.



my codes for the query is

 SELECT [Consolidated Denied Party Report].*, [Consolidated Denied Party Report].[26]
FROM [Consolidated Denied Party Report]
WHERE ((([Consolidated Denied Party Report].[26]) Like "*" & [All] & "*"));

The report was created via wizard based off the query....

[June7]

Calculate another value in query:

FoundCode: IIf([26]=[All],1,2)

Then use textbox conditional formatting to set the display according to FoundCode.

[NewbieInCT]

June, Sorry for the long lag. Where in my VBA code would I put this? would it be in the SQL query viewer part, or in the Altf11 area?

[June7]

That is not VBA code. It is intended to create a field in query with expression. The constructed field can be referenced same as any field in the query. Set Conditional Formatting of textboxes from the Format tab of the ribbon.

Setting formats on partial strings of text data is not easy. That would require VBA code, Rich Text Format, and HTML code tags.