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

Red line certain records

Status
Not open for further replies.

skystar70

Technical User
Nov 3, 2006
40
US
Hi. I am on version 9. Can I write a formula to put a red line through records that meet certain criteria? I only want the line to be red. I want the text to be black. I know I can make both the text and line red or both black by doing a font formula for strikeout. And I know I can put a red line through all records by inserting a line, but I cannot put a formula on an inserted line.

Any ideas or formulas I can write for this?

Thanks!
Skystar
 
I would create another formula with IF THEN ELSE logic that printed the line charcter when you wanted it to and nothing ("") when not. You will have to find the ASCII character for the line and then repeat it X number of times to fit the space of your field.
Save the fomula and then color it red. Then move it so that it overlays the field you want to format.

Howard Hammerman,
Crystal Training and Crystal Material
On-site classes and one-on-one coaching
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
You could use one side of a text box as a line. You can make the line conditional, and you can also color the border red.

-LB
 
Thank you both very much. I'm going to go with the one side of the text box. Much easier for me.

Skystar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top