Results 1 to 5 of 5
  1. #1
    HotelierDream is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2020
    Posts
    31

    Report Row Padding

    Hello all,

    I am new to access so you will likely see quite a few posts from me, I am looking for a developer but no luck yet.



    So I have a report that I am making to look exactly like an excel version of the report, I would like to make the access report have additional columns that fill the page.

    In example, a full page report has 16 columns before it needs to be printed on additional pages, if I only have enough records to fill 12 rows I would like to automatically create 4 additional blank rows so the report prints like a full report.

    Any ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Make a 'report table' that looks like the excel columns.
    add your data to the table.
    report on that.

  3. #3
    HotelierDream is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2020
    Posts
    31
    I must admit I am not following. I have made the report look identical to the excel workbook. I just need to make the report fill the page with blank rows so that it prints a full sheet.

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,566
    It would be easier if you can upload a zipped copy of the database so we can see what's happening.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    I first tend to look via Google?

    This is the first link in a search of 'pad access report with blank rows'

    https://vb123.com/how-to-pad-access-...th-blank-rows/

    and that link is https://www.google.com/search?q=pad+...hrome&ie=UTF-8

    HTH
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 16
    Last Post: 03-13-2018, 05:24 PM
  2. Replies: 9
    Last Post: 07-03-2017, 11:24 PM
  3. Edit Padding
    By pencheng in forum Access
    Replies: 5
    Last Post: 08-09-2016, 10:07 AM

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