color certain words in an expression

[Usaskater]

I have three columns:

Team	day	room
one​	tue	3​
two​	wed	4​
three​	thu	5​
four​
five​

In the query I made and expression DOWRM: ([team] & " " & [day] &" " &room]).
I placed this on my report and it looks great but I would like to have the following on a report

for example team one.... one tue 4

so the team would show and the day and room would be in color. I hope I explained it well! Many Thanks!

 

[bebo021999]

Not sure how many works is "team", but i assum day and room has 1 word each, so we have to find the 2nd space position form the right, then colour the remain text string from that pos?
With expression in column A:

Option Explicit
Sub ColorText()
Dim lr&, pos&, cell As Range
lr = Cells(Rows.Count, "A").End(xlUp).Row
    For Each cell In Range("A1:A" & lr)
        pos = InStrRev(Left(cell, InStrRev(cell, " ") - 1), " ") ' find 2nd space(1) from the right
        cell.Characters(pos, 255).Font.ColorIndex = 3
        Debug.Print pos
    Next
End Sub

 

[Fluff]

@bebo021999 I think you misssed the fact that this is in the Access section of the board.

 

[Joe4]

Have a look here and see if you can incorporate Conditional Formatting on your report:

Video: Use conditional formatting on reports - Microsoft Support

Conditional formatting allows you to apply different formatting to individual values on Access desktop reports, either based on the value itself, or on a calculation that includes other values.

support.microsoft.com

 

[bebo021999]

@bebo021999 I think you misssed the fact that this is in the Access section of the board.

À há, almost paid no attention. BTW, i got a change to practise at least. )

 

[Joe4]

À há, almost paid no attention. BTW, i got a change to practise at least. )

Yes, many people use the "Unanswered threads" listing to look for new unanswered questions to answer, and miss the forum listed under the question:

 

[Micron]

Not really enough info to provide definitive answer IMO. What colour would Wed. (Wednesday) be? What happens when 4 becomes 5? Might have to format the table field as rtf, and to do that it needs to be long text type (aka Memo).