473,395 Members | 1,956 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Page Break in Detail Section of Report

101 100+
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 3092
PianoMan64
374 Expert 256MB
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
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...
3
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...
1
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...
0
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...
4
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...
1
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...
13
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...
1
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...
4
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
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,...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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...

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.