Mailing Labels?

[Benny Wong]

Hello All,
I am using Microsoft Access 2000. I have created the report which is using the Avery Label using 5160. There are four rows for the label. The format is:

Row 1: First Name Last Name, Title
Row 2: Organization
Row 3: AltAdddress1
Row 4: City, State Zip

My question is in Access Row 1 data overlaps into row 2 and
everything else is moved down to the next row.
I am having a hard time tweeking it for 5 rows as well since this label supports only four rows. I have tried truncate the Row 1 data by counting how many characters across first name, last name, and title, but the client doesn't like the idea.
The client tried mailmerge into Microsoft Word 2000 and the label fits and now the client is complaining that Access can't do the job and I don't have the answer or clue to fix this problem in Access. I have tried to adjust it manually and tweeking the properties of can grow and can shrink but no fix.
Thanks for any help or suggestion in advance.

 

[pdx_man]

Can you reduce the font size/change font type? You are really limited by the type of labels that you have. Perhaps get bigger labels.

 

[Benny Wong]

Mailing Labels issues?

Hello pdx_man,
Thanks for your response. The user is insistant on the font type, size, and label. I know that the options are limited but I wanted to know what if there are any other fixes available before I present it to the user. If the user can states that the label fits in Microsoft Word and not in Access 2000 what should my response be? I guess that is my real question. What is the industry standards for this situation? Thanks for your suggestion in advance.

 

[pdx_man]

Hmm,
What is contained in your Control Sources? Does it look like?

=Trim([First Name] & " " & [Last Name] & ", " & [Title])

and so on ...

Make sure the width of the control is right up to the left and right edges of the detail section.
Perhaps you can buy some space by changing the settings in Page Setup. Select Columns and increase the width by what you decrease in the Column Spacing. Change the width of the detail section and your controls by this amount, too.

That is about all I can think of. Access and Word use the same font drivers, so ... This must be the only thing different between the two environments.