Add Blank rows to report

Posted on 2004-04-04
Last Modified: 2006-11-17
Hi Experts,

I have a report grouped by Companies.

I need it to have a minimum of  3 rows per Company ie even if the the Company has only 2 rows of Data I want the report to add a blank line.
I don't want to use a subreport.
I have an idea how to do it from the query but I'd prefer to do it from the report.
Question by:tbsgadi
LVL 54

Expert Comment

ID: 10751840
LVL 54

Expert Comment

ID: 10751857
Also read some comments down as perove did publish the code he used finally.

LVL 46

Author Comment

ID: 10752049
Hi Nic;o) the code there doesn't work,but anyway my case is different.
Perove in the end used PageBreaks
 I don't want a new page after each company.
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

LVL 54

Expert Comment

ID: 10752170
OK, then it's probably easiest to force an extra row in your query.
What is the relation between your company table and the 2 or 3 row table ?

LVL 46

Author Comment

ID: 10752182
I think I have it,
I'm adding a textbox using Chr(13) & Chr(10) &[Company] showing only if count(*) is <2
setting line spacing etc
This seems to be the easiest way out
LVL 54

Expert Comment

ID: 10752323
When you have no (or little) space between the rows that's indeed a brilliant plan :-)
Don't forget to have the CanGrow option set to "Yes" for the field.

LVL 57
ID: 10752813
For future reference: See the MoveLayout, PrintSection, and NextRecord properties in the on-line help.  With this properties, you can do all sorts of things, like repeating lines, dropping down the page, etc.

  For example, to print your blank lines, you could have done this in the OnFormat Section of the detail:

If <some condition> then
 .MoveLayout = True
 .NextRecord = False
End if

  By default, Access sets all these properties to true for each section print.  Changing them allows you to control the processing of the report engine in many different ways.


Accepted Solution

Computer101 earned 0 total points
ID: 11136956
PAQed, with points refunded (500)

E-E Admin

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
hit enter key to run macro 13 23
ms access 2010 vba, copy table from db1 to db2 from db3 27 46
Programmer 14 49
vba sql wild card passing in code 3 24
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question