Shrink text to fit

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Is there any way to have text in a report shrink to fit
the field size? I have name badges developed in a report
and I would like the text size to reduce automatically for
names that exceed the width of the badge.
-Brian
 
Is there any way to have text in a report shrink to fit
the field size? I have name badges developed in a report
and I would like the text size to reduce automatically for
names that exceed the width of the badge.
-Brian
Click to expand...

You can code the Detail Format event:

If Len(NameField])> 30 Then
[NameField].FontSize = 12
Else
[NameField].FontSize = 16
End If

A bit of testing will give the best number of characters to use.
Change the FontSize as desired.
 
Back
Top