Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Not enough horizontal space for columns specified?

Not enough horizontal space for columns specified?

Not enough horizontal space for columns specified?

Has anyone else encountered this problem using the Label Wizard?  I set up my labels in the wizard and select the size label from the wizard's list (Avery 5160) and it arranges the correct amount of space and columns, etc.  But when I go to view the labels or print, I ALWAYS get the msgbox telling me there isn't enough horizontal space for the columns specified and indicate that some data will be cut off.  What happens, however, is that the labels print perfectly as is.

What is the deal with this msgbox and how can I get rid of it?

(Hope this subject hasn't been done to death already on here but I've been having trouble using the search feature today - server trouble?)


RE: Not enough horizontal space for columns specified?

OKAY.  It seems this trouble is particular to Access 2002 and above?  I copies the Microsoft Article into this msg just info-wise.  But is there ABSOLUTELY no way to suppress this pesky messagebox?  It pops up on Preview and then AGAIN when you go to print.  Such a nuisance!  - Vie

CC2002: Warning in Label Wizard When You Use Three-Across Labels
View products that this article applies to.
This article was previously published under Q290282
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

When you use the Label Wizard to create a report, you may receive the following warning message if you are using three-across labels:

Some data may not be displayed.

There is not enough horizontal space on the page for the number of columns and column spacing you specified.

Click Page Setup on the File menu, click the Columns tab, and then reduce the number of columns or the size of the columns.
The total width of the report, including margins and the three-across labels, is greater than the width of the page.
The message is a warning and you can safely ignore it. You should not experience any loss of data when you print the labels.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
The label dimensions for certain Avery labels were modified in Access 2002 to be the Avery standard. In addition, certain labels may have a left margin that is smaller than what is allowed by many printer drivers. As a result, depending on the printer that you are using, the report may be created with a margin larger than the actual label.
Steps to Reproduce the Behavior
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

   1. Start Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
   2. In the Database window, click Reports under Objects, and then click New.
   3. In the New Report dialog box, click Label Wizard, click the arrow in the Choose the table or query where the object's data comes from box, click Customers, and then click OK.
   4. On the first page of the wizard, click Sheet Feed under Label Type, click the arrow in the Filter by manufacturer box, and then click Avery.
   5. Under product number, click 5260, and then click Next.
   6. On the next page of the wizard, leave the font and color at the default settings, and then click Next.
   7. On the next page of the wizard, under What would you like on your mailing label?, add the following fields to the Prototype label box, and then click Next: NOTE: Press ENTER in the Prototype label box when you want to start a new line.

      City, Region PostalCode
   8. On the next page of the wizard, click Next.
   9. On the next page of the wizard, click Finish. Note that you receive the warning message that is described in the "Symptoms" section of this article.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close