Shrink text to fit

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
 
F

fredg

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top