What behavior are you wanting? Field B to always be grey regardless of the color in field A?
As you have discovered, there are multiple ways in FileMaker to display text with a format (including color).
You can format the actual text data by pasting formatted text into a field or by selecting the text in a field while in Browse mode and using the formatting bar to format. Since the data itself is formatted, copying this data to another field also copies over the formatting.
You can, while in layout mode, select a field and use the same formatting tool bar or the Inspector's appearance tab to select a format for the field object on that one layout. Since this formatting is specified for the field object, not the data in the field, copying the data to another field does not copy over this formatting. It's not there to copy.
You can also use conditional formatting to control what text formatting is used to display the text. Like a format selected for the field object, this is also formatting specified for the field on a particular layout and cannot be copied with the data when copying it to another field.
If the text is always to be the same color, You can include the TextColor and RGB function calls as part of the "calculated result" parameter of your set field step to specify a text color. You can look up these functions in Help to see how to use them for this.
And this looks familiar so I am probably repeating myself with this comment:
It would be better NOT to combine these entries in a single field. It would be better to set up a portal with each entry in its own row with separate fields for the date, time, author and comment. Doing it this way limits what you can do with the notes thus entered.
1 of 1 people found this helpful
Wrap field A with the TextColor ( ) function like this:
metaData = List ( Get ( CurrentDate ) ; Get ( CurrentTime ) ; Get ( AccountName ) ) ;
Substitute ( metaData ; ¶ ; " - " ) ;
TextColor ( Table::fieldA ; RGB ( red ; green ; blue ) ) ;
Where RGB values are between 0-255 based on your desired color