Crystal Reports Change Font Size if length of field is certain length

I am using Crystal X1. I have a field that I want the font to be as big as possible depending on the length of that field.

So, if the value of the field is 20 characters long I want the font to be a size 24 because it will fit but if it is 40 characters long it needs to be a font of size 12 (for example) because otherwise it won't fit.

WHen I look at the font tab I see that I can put a formula behind the size but I do not know how to tell it which size to use and I cannot find it in the help.
Who is Participating?
peter57rConnect With a Mentor Commented:
I'm afraid there are no set rules.  Different fonts have different characteristics even if notionally the same size.
You'll have to work out your own rules based on testing various strings  and then set the value accordingly.  For example...

if length({table.field}) >40 then
elseif length({table.field})>30 then
elseif length({table.field}) >20 then
mlmccConnect With a Mentor Commented:
Another thing to consider is that the display is controlled by the printer driver so if the user of the report has a different printer, you may have to adjust the formula.

I find that it is a good idea to have the same printer driver installed on my machine (don't need the printer actually available) that the users of the report will have.  In that way the report will render on your machine the same as it does for the user.

bmorriso99Author Commented:
The first comment is the solution and the second is additional information that is extremely helpful. Thanks
All Courses

From novice to tech pro — start learning today.