Results 1 to 5 of 5
  1. #1
    george3095 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    3

    Too many blanks in Labels

    I've begun, for the first time, creating mailing labels starting with an Excel Workbook imported into Access. When I get to the point of previewing the labels, there seem to be maybe 10 blank labels. I don't have a clue how this could happen but I obviously don't want to waste the ten or so labels (out of about 90 total). I have started again from scratch doing what might help, such as setting the print area and removing empty Worksheets, but nothing helps. HELP!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    It sounds like there are empty records in the Access table. If so, they should be deleted or at least filtered out.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    george3095 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    3
    Thanks, pbaldy, but, since I started with an Excel spreadsheet and I specifically selected that only the print area be used, I just can't see how the blank fields could happen. The blank fields included the first three rows and the first field from the fourth row, for a total of 10.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Can you post the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    george3095 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    3
    Well, now, Paul, I'd be really, really reluctant to publish the names and addresses of my 93 friends and relatives to whom my wife and I send Christmas cards. But, take my word for it: Row 1 contains the Headers (LastName, FirstName, Address1, Address2, City, State, PostalCode). The Number 2 Row contains data for the first person. The Print Area contains Row1 to Row 94 from Aolumn A to Column G. There are no blank cells (except for those cells, like many in Address2, that are necessarily blank. But, the anomaly is not the end of the road and here's why: to my disappointment, once Access had created the Access version of the Excel DB, I discovered I could NOT edit individual address lines to shorten lines that were too long for the printable area for any individual address. I was forced to change the font size of the entire Access DB. So, I then began with Word and used the Excell DB. Problem solved. I could change the font size of, say the line, FirstName, Lastname, of any address label without affecting the entire printable DB.

    Thank you for your effort to help but, in spite of it being much easier to use Access/Excel to create a printable address label DB, the Word/Excel combo gave me a totally-editable final product.

    Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Conatenate fields and also remove blanks
    By Rubijon in forum Reports
    Replies: 3
    Last Post: 10-23-2011, 05:29 PM
  2. Fill in blanks from another table
    By HectorH in forum Queries
    Replies: 1
    Last Post: 08-26-2011, 05:13 PM
  3. SQL Update with blanks
    By Tyork in forum Programming
    Replies: 1
    Last Post: 12-17-2010, 10:12 AM
  4. Access filter does not show blanks
    By Jaricketts in forum Access
    Replies: 1
    Last Post: 03-26-2010, 05:38 PM
  5. Adding columns that contain blanks.
    By Tony McGuire in forum Access
    Replies: 11
    Last Post: 05-31-2009, 12:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums