473,834 Members | 1,491 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Page Break in Detail Section of Report

101 New Member
Hi,
I have one project in MS Access.
In that I have one form in which I am using one combobox and one search button.
Now when I select an item from that combobox and press the submit button then it will generate the report base on the selection of combobox.
Now that report is generated by the using wizard whose source code is Table PRODCUTION.
Now when I search and if there are more than 20 line in report than I want to force new page and next 20 line must come in new page.Rest like that.
I want to put this page break in Details section of the Report.

Plz Reply as soon as possible.
Thanks.
Dec 11 '07 #1
1 3136
PianoMan64
374 Recognized Expert Contributor
The simplest way to achive that is to change the margins on the report to only allow 20 lines of report information to print, then it will do a page break and print more on the next page.
Jan 5 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3906
by: Eddy Bee | last post by:
Hi there, I'm encountering an inexplicable problem with page formatting in reports. Here's the easiest way to explain it: The Detail section of my report contains two elements: And let's say I have the following VB code for the Detail_Format event:
3
6121
by: mark | last post by:
How do I get all fields on one page of a report? I have a report that has a column for each day of the week and 6 records for each day. I need each weekday's records returned on only one detail page. Instead I am getting a new table layout for each day of the week. I have tried grouping on every record and combination I can, manipulating the Group Properties but can't get it right. I have the entire report in the Detail Section, with...
1
2346
by: Dave | last post by:
I have a report set up with the following hierarchy in the design mode __________________________ PAGE HEADER PRODUCT HEADER PRODUCTDESCRIPTION HEADER DETAIL PAGE FOOTER __________________________ The problem is that when my report is generated the PRODUCT HEADER and
0
1718
by: Arnold | last post by:
Hi Everyone; In a report, I've essentially recreated a paper sheet by adding various labels--name, date, problem, year, Progress Notes, etc.--and horizontal lines (people have traditionally written notes). I made all of these in the Page Header section. By the way, this is a report form to track the daily progress of students. --Report Header--none. --Grouping section--yes. The report form has a StudentID Header, which
4
21586
by: Rico | last post by:
Hello, I'm looking for a way to force a pagebreak in code. I'm having a tough time, the first page formats properly until the condition is met and then forces a new page. The problem is, every page after that forces a new page after a single record. I'm trying to force the page after 12 records. The code is pretty simple. I have a footer called "BreakFooter" that i have associated with the ID field, so each detail record is unique....
1
3594
by: David | last post by:
Folks, I have four subreports in a report in the detail section. I suppose I could move them to the footer of the report. Anyway, if any of them have data, I want the main report to force a page break. I am trying to use the "hasdata" property for the subreports, but I am getting the generic error indicating property not available for object. How does one tell the main report (using VBA) not to throw in a page break unless the...
13
14950
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would show on only the top half of each page with whitepace at the bottom of each page. How can I get the detail to fill each page with my "half page height" report footer at the bottom of the last page? Any suggestions to solve this would be...
1
2326
by: Daniele | last post by:
I have to create a report, that contains in the section body a list of record. For every record it has to appear an incremental additional field that begins from One; when he reaches the record 50, it is had to activate a page break and the following record leaves again with numeration equal to one. How can I do?
4
13009
by: JHite | last post by:
I'm using AC2003. Sequence of events: a. Tool -> Relationships I show my tables & relationships and arrange them to fit landscape mode. b. File ->Print Relationships This generates a report in portrait mode with name/date etc. in report header section, an empty page header section, and diagram of relationships in detail section. c. I go into setup, change to landscape orientation and adjust margins so my "print" is not too...
0
9796
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10790
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10505
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10214
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9329
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7755
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6952
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5790
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4425
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.