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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

function commands 1

Status
Not open for further replies.

Phillipg

Technical User
May 3, 2002
53
US
I have looked every where, hope some one can help.
Im looking for a list of commands that I can use to conditionally change the font, color, size etc.
I know how to set up the formula with some commands and would like to know what others are available.
I conditionally change the color with:
if {table.value} >= 5 then red
this works fine and with some if, then, else formula's also.
Thanks

Phillipg
 
If you click on the X2 button beside the color on the font tab, under Format Field - then you should be taken into the formula editor - provided you get there from an area that allows you to control color attributes, then the formula editor will list the colors available under Color Constants.

Peter Shirley
 
Here's some Constants for use in formulas, ther aren't any commands that I'm aware of:

Constant Description
crRegular
Format font in regular type face.

crBold
Format font in bold type face.

crItalic
Format font in italic type face.

crBoldItalic
Format font in bold italic type face.

For the size just use a number

You can also use HTML in the field to allow for basically anything HTML uses by right clicking the text field->Format Field->Paragraph Formatting->Text Interpretation->HTML Text

-k
 
Trust me - right click on any field, select Format Field - go to the attribute that you want to find the constants for e.g. Color on the Font tab, click the conditional formatting button (X2). Wallah! - in the functions window will be listed all of the constants that apply to the type of formatting you are changing.

Peter Shirley
 
Thanks Peter aka crystalreporting.
guess I need to open my eyees and see that functions list does change.

Phillipg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top