Fit top line on address label

[Ron]

I have a report set to print addresses to labels. The
problem I'm having is the occasional oddball with a mile
long name.

Currently I have it set to 42 characters.
The top line consists of:
=trim([Greeting]&" "&[FirstName]&" "&[LastName])

I have it counting the characters and chopping off the
greeting if it's too long, but I'm STILL getting freaks
with 42+ character names.

Any suggestions on this? I'd really rather not go to a 6
font on ALL the labels just for a few oddball names.

Thanks!
RJ

 

[Duane Hookom]

You might want to check Stephen Lebans solution at his site
http://www.lebans.com/autosize_textbox.htm.