?
Solved

Add Blank rows to report

Posted on 2004-04-04
9
Medium Priority
?
627 Views
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.
0
Comment
Question by:tbsgadi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 10751840
0
 
LVL 54

Expert Comment

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

Nic;o)
0
 
LVL 46

Author Comment

by:tbsgadi
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.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 54

Expert Comment

by:nico5038
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 ?

Nic;o)
0
 
LVL 46

Author Comment

by:tbsgadi
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
0
 
LVL 54

Expert Comment

by:nico5038
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.

Nic;o)
0
 
LVL 58
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
 .PrintSection=True
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.

Jim.
0
 
LVL 1

Accepted Solution

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

Computer101
E-E Admin
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

741 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