Results 1 to 2 of 2
  1. #1
    georgia is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010

    creation of reports with fixed number of rows

    Hi, I can't seem to figure out how to create a basic report with a set number of rows. IE: a report that has to have 20 rows, but only 5 items are returned on a query, therefore 15 rows will be empty, but need to be physically seen on the report.

    Ex: report detail section must have 20 items numbered 1 - 20. 5 items are returned so we normally end up with 1 - 5... Now I have to "trick" the report into printing 15 more rows 6-20 with empty boxes.

    any ideas?


  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Houston, Texas USA
    (1) Have your reports record source retrieve 5 records (only) with a query {hopefully it's the first 5 records] or
    (2) add a hidden counter in thye detail section of your report, the value of which is tested on the report's Detail Section's OnFormat event, if > 5 hide all the controls in the detail section, otherwise show all. This creates a blank line for each hidden row; more machinations are involved to elimiunate it.

    The first method is superior, unless footer totals are involved, which requires even more machinations.

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

Similar Threads

  1. Replies: 5
    Last Post: 09-16-2009, 01:56 AM
  2. Report like a fixed form
    By mikr in forum Reports
    Replies: 0
    Last Post: 08-30-2009, 12:25 AM
  3. Formatting Fields and Fixed Width Exporting
    By Panman01 in forum Access
    Replies: 1
    Last Post: 05-22-2009, 09:32 AM
  4. help with database creation
    By terrep263 in forum Database Design
    Replies: 1
    Last Post: 08-30-2006, 07:59 AM
  5. Use fixed height and width for the Access window
    By AndrewAfresh in forum Access
    Replies: 3
    Last Post: 07-05-2006, 09:20 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