Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Not enough horizontal space for columns specified?

Vie (TechnicalUser) (OP)
29 Jan 04 17:01
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?)

Thanks!
Vie
Vie (TechnicalUser) (OP)
29 Jan 04 18:23
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


MS KNOWLEDGE BASE:
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).

SYMPTOMS
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.
CAUSE
The total width of the report, including margins and the three-across labels, is greater than the width of the page.
RESOLUTION
The message is a warning and you can safely ignore it. You should not experience any loss of data when you print the labels.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
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.

      ContactName
      ContactTitle
      Address
      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.

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