retaining colurs on concatenated fields

[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

 

[Rick Brandt]

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

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.