473,507 Members | 2,473 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Cannot get my access 2010 report to perform a page break after change of record

2 New Member
I am a newbe Access 2010 'person' and have designed a simple membership record database consisting of a main and subform. I want to print a membership handbook with a page for each member. I Created a report consisting of data from the main and subtables and although I can see all the data i cannot get the report to page break after each member record. I have tried to place the 'force page break' after the section, but I think it is something to do with the report layout and grouping.
Jun 4 '18 #1
4 1120
twinnyfo
3,653 Recognized Expert Moderator Specialist
macctravelman,

Welcome to Bytes!

Where are you putting the "Force Page Break" in your Report? There are several places it may go, which may affect how your report is functioning?

Also, as a general rule, users and experts on this forum will not download someone's Access project (especially a first time user) for obvious security reasons. There may be times when we ask for it, but it is rare.
Jun 5 '18 #2
macctravelman
2 New Member
hi
Thanks for your advise, I had changed the data within the tables to ensure that the names and other data was fictitious. I have zipped the tables, forms and reports so you should be able to determine where the force page break is located
Jun 5 '18 #3
twinnyfo
3,653 Recognized Expert Moderator Specialist
Again, as a general rule we don't download projects. Please respond to the question directly please.
Jun 5 '18 #4
NeoPa
32,557 Recognized Expert Moderator MVP
How to ask "good" questions -- READ BEFORE SUBMITTING A QUESTION! should help you to get more from this forum.
Jun 9 '18 #5

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

Similar topics

2
3414
by: Les Desser | last post by:
I am trying to use a conditional page-break by setting the Visible property of the page-break control - as per the Access Help. However, my page-break controls do not have a Visible property! :(...
1
2323
by: tngoe | last post by:
I haven't programmed in Access for five years. The budget analyst asked me for help. Her report has page break after each group of organization. However, when posting this report on e-print...
0
1660
by: Tom East | last post by:
I am a special ed teacher. I am using Access to track data. My ultimate goal is to provide parents with a scatter chart with a trend line based on two fields from a trial results database. The fields...
3
19435
by: minnichj | last post by:
Is there a way to force an Access 2010 report to resize so all columns print out on one page (I'm looking for something similar to the "Fit to:" Page setup feature in Excel)? VB Code preferred.
4
10487
beacon
by: beacon | last post by:
Hi everybody, My title may not exactly describe my issue, so please forgive my lack of creativity today. I've got a database that was created in Access 2003 that I've opened in Access 2010. I...
7
8884
by: Sophia Olivas | last post by:
I am trying very hard to make this work - i found a question posed a few years ago to do the same thing and tried the solution but it doesn't work... I have a standardized form that I am trying to...
1
1823
by: newtoaccessvba | last post by:
I am not too familiar with VBA in Access, but I would like if someone could show me how to ignore a caption and it's field in an Access 2010 Report and an Outlook Email when the field value is it is...
3
1824
by: jyellis | last post by:
My customer wants to see the records updated in the last 30 days to change color on his report. There is no update date field in report. Can this be done?
3
14640
by: rahul2310 | last post by:
I have created joining letter in access 2010,as it is a letter it is not in column and row format. When i export report to word it does not shows report instead it shows column headings and data...
0
7221
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,...
0
7109
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
7313
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
7372
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...
1
7029
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
7481
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...
0
4702
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...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
758
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.