Can I change the font size in a formula?

[cjbrown815]

Hi, I have a field that occassionally gets commentary in it. When this happens the commentary runs off the field. I want to change that commentary to a smaller font when it happens. I know I canchange the color and the style, but, what about the size?

The commentary is always either "SPREADER", "TNTC" or "NR"

thanks

CrNine ??

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[lbass]

Sure. Select the field->right click->format field->font->size->x+2 and enter your conditions, e.g.,

if len({table.field}) > 4 then
8 else 10 //or whatever font sizes you want

-LB

 

[cjbrown815]

Thanks,
I didnt know if it was like CrRED or CrBOLD

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931