Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Inserting a forced page break in an Access Report?

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Inserting a forced page break in an Access Report?

Old 02-12-04, 10:40 AM
  #1  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Oct 1999
Location: not CT
Posts: 9,615
Inserting a forced page break in an Access Report?

I need to figure out how to force a page break in a report generated by Access. I have negligible working knowledge, so please bear with me if I'm missing something obvious.

I'm trying to develop a setup database for a piece of equipment. The equipment can have 100+ configurations based on the tooling used. I want each page of my report to list the configuration name as well as the individual pieces of tooling necessary for that configuration and nothing else. In effect, I want each page to be a "recipe card" of sorts.

Any ideas as to the best course of action?
BigPete is offline  
Old 02-15-04, 02:55 PM
  #2  
DVD Talk Hall of Fame
Thread Starter
 
Join Date: Oct 1999
Location: not CT
Posts: 9,615
Nobody uses Access, huh?
BigPete is offline  
Old 02-15-04, 11:10 PM
  #3  
Senior Member
 
Join Date: Oct 2003
Posts: 400
well, it's always hard to advise with such sketchy information.

Access doesn't have the ability to simply "plop" a page break wherever you want it.
You need to have some field that you want a page break after each entry in that field.

Do you want a page break after EVERY different configuration?

If so, you could Group your report by the Configuration field (use the Wizard - it's the easiest way, by far), then go to the design and go to the Properties of the DetailSection and change the "Force New Page" property to "After Section"....
reapersaurus is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.