CR7 - Changing a Field's Font Based on a Formula 
Author Message
 CR7 - Changing a Field's Font Based on a Formula

Hello,

Does anyone know how to change a field to bold (or underline it) if it's
value is within a certain range.
I can change the background of the field in the detail section using this
formula attached to the background

if ToNumber({Milage}) > 50 and ToNumber({Milage}) < 100 then
    // it's here I want to change this field to bold
    red
else
    white

But I really want to change the fields font. Any answers would be greatly
appreciated



Sat, 11 May 2002 03:00:00 GMT  
 CR7 - Changing a Field's Font Based on a Formula
If you look in the Font dialog box, the only condition you can change is the
color. What I've done for clients is create two text. Same text, same size,
overlaid. And then use a formula similar to yours to suppress one or the
other. Not elegant, but it did work.

Brian

Quote:

>Hello,

>Does anyone know how to change a field to bold (or underline it) if it's
>value is within a certain range.
>I can change the background of the field in the detail section using this
>formula attached to the background

>if ToNumber({Milage}) > 50 and ToNumber({Milage}) < 100 then
>    // it's here I want to change this field to bold
>    red
>else
>    white

>But I really want to change the fields font. Any answers would be greatly
>appreciated



Sun, 12 May 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Create Formula Fields at run-time with CR7

2. Sort a group based on a formula field

3. How to Sort a group based on a formula field

4. Change Formulas Font at runtime in Crystal Report

5. How to Change Fonts through Formula

6. Control's BackColor Based on Field's Required Property

7. Changing font colour in an Access report based on a date

8. change label's font's script in runtime

9. Dynamically change formula field

10. Changing Value in Formula Field

11. fields didn't show up when using a formula in a report

12. Question about formula's fields

 

 
Powered by phpBB® Forum Software