Alter Font Size in Formula

[diggers80]

Could anyone tell me how to alter the font size of a field within a formula. ie if true then have a bigger font else font smaller.....

Any help / advice would be appreciated.
Cheers

 

[Naith]

Right click your formula, select Format, and next to Size you'll see the condition editor button (X+2).

Enter

If {@MyFormula} < 999 Then 10 Else 8

(or whatever your condition is supposed to be).

Naith

 

[diggers80]

Naith,
Thanks for this, however there isn't an editor button next to Font Size. There is next to colour and using your principle i can get the colour to alter.

I'm using crystal reports V7.0.

Any other suggestions?

 

[Naith]

Ah, 7...

Well, my next trick would have to be HTML formatting. Apply

<font size = 1>

to your formula, but to be fair, I'm doubtful that this is 7 compliant.

Naith

 

[basil3legs]

Create either 2 identical sections or 2 copies of the field for which the font needs changing. Set one copy to one size, the other to the other size and conditionally supress them both depending on your formula. One will need to be supressed if the formula is true, the other if it is false.

A long way round but it works in version 7 just fine.

 

[diggers80]

Cheers Mr 3legs...
This is how i ended up doing it.
Diggers !!