Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2018
    Posts
    4

    Reducing row spacing inAccess 2016 Report

    I am using Access 2016 and creating some reports that will be accessing a table with possibly as many as 3000 records. I need to print out a one-line per record report. Therefore I need to maximize the # of records (or rows) per page to minimize the amount of paper being used. I have attached a word file (ZIP) with 3 screenshots where the first is the actual printout of a sample table. The second shows the properties of the "CAT Key Field Header" with the text boxes for the data. The third shot shows the properties of the Year data text box. I tried to set the data text box size at .15" but using a 9 pt. Font cuts off the bottom of the "y" letters so I used .155 (Access changed it to .1549"). I tried to set the height of the CAT Key row at .20" but no matter what I do, Access insists it can't be any smaller than the .2188" shown.


    Is there any way I can bring the rows closer together without making the Font any smaller ?
    Attached Files Attached Files

  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,642
    The second is the detail section, which it looks like you can drag up to the bottom of the textboxes. If you can't, some control is blocking it, perhaps off to the right of the part visible in your picture. It could also be hidden by the bottom of the detail section, so drag it down first and see if anything is there.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,706
    As Paul indicates, you should be able to drag the bottom of the detail section up flush with the bottoms of the textboxes.
    If not, post your db here with just the report in it.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-04-2018, 02:35 AM
  2. Report spacing issue
    By SBlakeS in forum Reports
    Replies: 1
    Last Post: 05-13-2016, 09:36 AM
  3. Replies: 1
    Last Post: 02-04-2013, 12:06 PM
  4. Replies: 1
    Last Post: 01-12-2012, 02:54 AM
  5. Reducing code
    By Mclaren in forum Programming
    Replies: 7
    Last Post: 03-16-2011, 02:45 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