Apply italic to concatenated text string in query (1 Viewer)

TB11

Member
Local time
Today, 13:20
Joined
Jul 7, 2020
Messages
78
Hi.

I have a concatenated text string that I would like to have part of it in italics, that I can then use that string in a report.

String: "First part: " & [FieldA] & ", " & "second part " & [FieldB]

Wish: "First part: " & IN ITALICS [FieldA] & ", " & "second part " & [FieldB] END ITALICS

I don't know how to handle the html code insertion into the text string.

Any suggestions?

Thanks.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:20
Joined
Aug 30, 2003
Messages
36,118
You insert HTML tags within the string, along the lines of

String: "First part: <I>" & [FieldA] & ", " & "second part " & [FieldB] & "</I>"
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:20
Joined
Aug 30, 2003
Messages
36,118
Note to my knowledge you can only view that in a form or report with a properly formatted textbox.
 

TB11

Member
Local time
Today, 13:20
Joined
Jul 7, 2020
Messages
78
@pbaldy THANK YOU, it worked! I never would have got there on my own. I appreciate the reminder to change the text box property on the report to rtf.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:20
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom