Change font formatting in a concatenated string

[Guest]

Following on to the previous question "How do I insert a hard break (alt
enter) in a concatenated string" where the answer was by inserting a CHAR(xx)
string I wonder whether there are similar codes to eg make one element of a
concatenated string bold or italic or underlined or ...

This would come in particularly handy with strings that are displayed in
text boxes - very practical for variable explanations on graphs.

My current workaround is to put the string elements in separate text boxes,
format them as required and then group them together.

 

[Bob Phillips]

No there isn't. You need to use VBA to set the specific elements, but it is
a bind (IMO).

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)