Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to join two fields and make the resulting fonts different colours?

Status
Not open for further replies.

NeilT123

Technical User
Jan 6, 2005
302
GB
I have a text box on a report with control source =[ProductName] & " - " & [ProductComment]

The font colour of the text box is blue and font size is 14. Is there any way to retain that formatting for [ProductName] but have [ProductComment] in a smaller red font?
 
Yes, but not very easy. You would need to use richtext. Then build a UDF function where you pass in the two values and concatenate in the appropiate rich text tags.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top