Shrink text to fit into text box

[dwanjk]

Hello,

I am creating a 1 page document that contains a text box in the body of the document. Is there a way to shrink the font of the text to fit in the box? I do not want to select "can grow" because this will cause the document to be more than one page.

Thanks in advance for any help you can provide.

J

 

[IdoMillet]

If you want to dynamically reduce the font size to the point where the text fits within a given length, one of the 3rd-party UFLs listed at

http://kenhamady.com/bookmarks.html

has a function: GetTextWidth (Text, FontName, FontSize, Bold, Italic, Units) that allows you to control the font size and adjust it to a point where the text is less than a given width.

hth,
- Ido


view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IanWaterman]

Assuming the text is a field, you can dynamically change font size depending on number of characters in field. This will not be truly dynamic as you have to test text lengths to suit, but means you can code yourself.

Right click field (not text box) and select format -> font

In formula box opposite size

If length(yourtextfield) >= 50 and length(yourtextfield) < 100 then 10
else
If length(yourtextfield) >= 100 then 8
else 12

Change values to suit your needs

Ian

 

[dwanjk]

Thank you both for your response. Although it looks like Crystal can't do exactly what i am looking for, I think Ian's formula can work for this report. Thanks again!