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!

Register Log in
  • Congratulations Mike Lewis 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

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?
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
930
EwaFAMA
EwaFAMA
breezett93
  • Locked
  • Question
Text cut off even though the text box is large enough
Replies
16
Views
767
strongm
strongm
Zandy12
  • Locked
  • Question
Repeat the Report Header after Page Header / Details ends.
Replies
1
Views
449
dhookom
dhookom
JohnXr
  • Locked
  • Question
thread703-757058 I use the followi
Replies
4
Views
222
Axworthy
Axworthy
caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
201
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top