Change font in a concatenated field???

[spining123]

Is it true that you can not change the font with fields that are concatenated?
I have a run on report with 20 concatenated fields, which is now a formula field I created to format the data. Again, thanks to Dave for the help with the slash insert.

If possible I would like to change the font for the third concatenated field in the formula. Is there any way I can do this using the font or size in the formula of the concatenated fields?

Example: field1 & " " & field2 & " " & field3

How can I change the font for field3 in the formula?

I created a formula to format

 

[RJFost]

Wow- never tried that one. I'd go with putting fields 1 & 2 into one text field & field 3 into its own field (which I could then format to my heart's content, independent of the other 2).

 

[dgillz]

I am pretty sure I have seen this before. You can use html tags in your formula to achieve this effect.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[vidru]

You have a couple of options...

1) Break up your formula into sections and concatenate them using a text field, changing the font attributes of each formula as necessary.

2) Format the resulting formula as HTML. That would require some changes to your formula. Something like this:

field1 + ' ' + field2 + ' <font face = arial>' + field3 + '</font>'

Then, you'd drop your formula on the report, right click and pick 'Paragraph Formatting', then set Text Interpretation to HTML Text.

-dave

 

[RJFost]

Definitely never went that route. So far, we've avoided using html in reports (long story)...didn't mean to seem ignorant, just innocent. Glad someone else was on the ball.

 

[spining123]

Thank you very much RJFost, dgillz, and Dave [/color blue]. You guys are great!

The fields are concatened to allow only 2 spaces between each variable field length. This reduces the number of pages for the report. It is just a quick reference report.
I used the html bold tag and changed to Text Interpretation, as suggested, in the Format Editor under Paragraph.

Again, Thank you