Link to home
Start Free TrialLog in
Avatar of janjuama84
janjuama84

asked on

How to bold the string in formula

I am using the following formula and want to bold the string "Functional Enquiry". How can i do this?

IF {Print_Patients.Pfe}<> "" THEN
"Functional Enquiry: " & {Print_Patients.Pfe};
Avatar of bdreed35
bdreed35
Flag of United States of America image

Change the formula to this:

IF {Print_Patients.Pfe}<> "" THEN
"<b>Functional Enquiry: </b>" & {Print_Patients.Pfe};

Then once you save and close the formula editor, right click the formula and choose format field.
Under the Paragraph tab, change the Text Interpretation drop down to HTML Text
Avatar of janjuama84
janjuama84

ASKER

I checked under text interpretation only options are rtf text or none.
Avatar of Mike McCracken
What version of Crystal?

You can do a similar thing using the RTF bold/unbold formatting.

mlmcc
i am using crytal reports which is in visual studio 2003.

It might be easiest to create the text outside of Crystal and save it as an RTF then open the file with Notepad and copy it into Crystal.

mlmcc
You could also just put it in a text object, bold the label, and then format it to conditionally suppress if {Print_Patients.Pfe}=""
VS2003 version doesn't have the HTML interpretation.  You can still use bdreed's suggestion, just do the rtf interpretation and surround your text with rtf tags.  For bold:

"This is \b bold \b0"

frodoman
How will i use the rtf tags for bolding "functional enquiry"
IF {Print_Patients.Pfe}<> "" THEN
"Functional Enquiry: " & {Print_Patients.Pfe};
IF {Print_Patients.Pfe}<> "" THEN
"\b Functional Enquiry: \b0" & {Print_Patients.Pfe};

Note that you'll need to set the interpretation to rtf for this to work - otherwise you'll actually see \b and \b0 in your output.
I did set that. It still shows \b Functional Enquiry\b0 in output.

ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial