Hello All,
I am currently working with Access 2000. I am trying to create a mailing label. The label is setup as:

FirstName LastName, Title
Organization
Address
City, State Zip

The problem that I am having is the Organization character
wraps down to the next line on the Address line. I would
like to limit the Organization line to only 30 characters.
How can I do this. This is currently what I have:

Public Function Avery_Organization(Organization)
' Trim to 30 characters only starting at 1 to 30
If Len(Avery_Organization) > 30 Then
Avery_Organization = Mid(Avery_Organization, 1, 30)
End If
End Function

Thanks for any help or suggestion in advance.

Set the 'Can Grow' to No on the Org field and report details properties.