Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Text to bold in formula

Status
Not open for further replies.

sbalun

Programmer
Feb 12, 2001
62
US
Hi.

I have the following formula:
--------------------------------------------------
numberVar validityDivisor := 4;
Global numberVar validityAmount := {schoolInfo.TotalPopulation}/validityDivisor;
Global numberVar responseTotal;


"Since you reported your population to be " + ToText({schoolInfo.TotalPopulation}) + " you needed " + ToText(validityAmount) + " surveys to have a valid sample." +

" Therefore, the data in this report is: " + Chr (13) + Chr (13)

if validityAmount <= responseTotal then
&quot;YES, Data are Valid (see box below - Column A for explanation)&quot;
else
&quot;NO, Data are Not Valid (see box below - Column B for explanation)&quot;
--------------------------------------------------------

Everything is working correctly EXCEPT I'd like to have the text output from the If-then-else statement printed in BOLD. Right now it's coming out like all the other text on the page.

I'm not sure what to do? Any help would be much appreciated.

Thanks.

--Scott
 
You've 2 solid options.

Preferred:

Create a separate formula for the BOLD font, drop both formulas into a text field, highlight the formula you'd like to have bolded, and click the bold button - purdy simple.

Alternative:

An alternative is to use HTML in the formula, as in:

&quot;<B> &quot;YES, Data are Valid (see box below - Column A for explanation)&quot; </B>&quot;

Right click the field and select format field->Paragraph Fromatting->Text Interpretation->HTML

But I suggest you go with the above as then you'll have to play with sizing too.

-k
 
Yes it can be done
example
in a formula
on the field {manager}
right click on that field and in the font style
click on the x2 and insert this condition
-------------------------
if
{mamager} then CRBold
else
if
{Director} then CRItalic
else
if {Volunteers}then CRRegular
------------------------
NOW FOR COLOR FONT
you will go the windows of font and in the section COLOR
click on the x2 and type this
-------------------
if {Volunteers} then Red

----------------------

or what color you prefered type it in

hope this helps you

pg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top