Formula Editor, Conditinal Formatting

[TomChmiel]

Hello,
I have two questions....
1)Is it possible to make runtime modifications to conditional formulas in CR.NET like this:
I have 5 fields in table. 4 of them store data and the last one Font Name for Field1 to Field4:

Field1 | Field2 | Field3 | Field4 | Field5
----------------------------------------------------------------------
John | Smith | Warsaw | 30 |Field1:"Tahoma";Field2:"Arial"....
Mary | Black | London | 25 | Field1:"Courier";Field3:"Arial"

I want to change Font Name of Fields1-4 like described in Field5.
Is this possible?
2) Is there in Formula Editor function returning current Field name (like function CurrentFieldValue returning current Field value) ?

Than You very much for Your help
Tom

 

[lbass]

This formula worked when I tested it, assuming your Field 5 is laid out exactly as you showed, with each segment delimited by a semicolon.

You would have to format each of the fields 1 to 4, and change the number in the quotes to correspond to the field you are formatting. Go to format field->font->x+2 and enter:

if instr({field5},"1&quot > 0 then mid({field5},instr({field5},"1&quot+3,instr((instr({field5},"1&quot+3),{field5},";&quot-1-(instr({field5},"1&quot+3))
else DefaultAttribute

-LB