Fit top line on address label

  • Thread starter Thread starter Ron
  • Start date Start date
R

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
 
Back
Top