retaining colurs on concatenated fields

  • Thread starter Thread starter limpetsfolly
  • Start date Start date
L

limpetsfolly

I'm concatenating a few text boxes into one and I want to be able t
retain the colours of the text from the individual text boxes, bu
Access seems to use the format of the receiving text box.
For example, [Text_Box1]=[Text_Box2]&[Text_Box3]where the contents o
[Text_Box3] are red, [Text_Box2]in blac
 
limpetsfolly said:
I'm concatenating a few text boxes into one and I want to be able to
retain the colours of the text from the individual text boxes, but
Access seems to use the format of the receiving text box.
For example, [Text_Box1]=[Text_Box2]&[Text_Box3]where the contents of
[Text_Box3] are red, [Text_Box2]in black
Click to expand...

All standard Access controls have one format for the entire control. You cannot
format some of the text differently. For that you would have to use a Rich Text
ActiveX control. On reports you can use the print method to get the output on
the report instead of using TextBoxes and then you could change the formatting
as often as you want.
 
Back
Top