This is probably very simple: How do you place two calculations in a field (auto-enter data section)? If I just place these two calculations (see below) in this area, it gives me an error "An operator is expected here".

Any help is greatly appreciated in advance.

Shane

Case(Active = "Y"; TextColor (Medication ; RGB ( 58 ; 110 ; 165 ) ); TextColor ( Medication ; RGB ( 161 ; 161 ; 161 )))

Case(Active = "Y"; TextStyleAdd ( Dose ; Bold ); TextStyleRemove (Dose;Bold))

Put & " " & between them.

Queue,

First of all, thank you for the tip. I tried your suggestion, but what was returned looked something like this:

Text (original without formatting statements)

Text Text [color:"blue"] (Duplicated the field contents and added the appropriate color and bolding)

All I want is to format a field that changes color (blue shade) and bolds the text when the condition is true, otherwise, the text will be gray and plain style. Any other thoughts?

Shane

These two functions refer to two different fields -- Medication and Dose. I think the functions should both refer to the same field, and be cascaded:

TextStyleAdd ( TextColor ( Medication ; RGB ( 58 ; 110 ; 165 ) ) ; Bold )

rsgfmp: are you saying that you want the field background to change color and the text inside the field to be bold?

Make each of the fields "Medication" and "Dose" auto enter calcs so that

Medication: If(Active = "Y"; TextColor (Medication ; RGB ( 58 ; 110 ; 165 ) ); TextColor ( Medication ; RGB ( 161 ; 161 ; 161 )))

Dose: If(Active = "Y"; TextStyleAdd ( Dose ; Bold ); TextStyleRemove (Dose;Bold))

Make sure you uncheck "do not replace existing value..." of each auto enter calc

Vaughan,

Thank you very much! Works great! Also, thanks for figuring out the field "medication" was supposed to be in the second line as well instead of "dose". I apoligize for the confusion to others and appreciate everyone's input. I'll try not to make that kind of mistake again.

Shane