• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

Access 07 report export to RTF - 1 pg. per record is output

When I export to RTF, the doc is opening in print preview for most.  Because each record is separated by a dotted page break (counting as 1), preview appears as solid lines and no data.  The average recipient will not pick up on this and assume the doc is unreadable.

Not the end of the world, but can this be corrected on the server end in the Access export?
0
Cole100
Asked:
Cole100
  • 5
  • 4
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
If this in fact a real page break, then why are the dashed lines needed at all?
0
 
Cole100Author Commented:
They are not needed.  I would like to avoid the page breaks.  When trying to print this document i get 1 record per page.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Cole100,

Then delete the page break in the Source Report(s)

Either there is a manually inserted page break, that you can literally delete.

Or, on one of the Report sections, the "Force New Page" property is set to: YES. This setting needs to be set to: NO

JeffCoachman
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Cole100Author Commented:
Is this setting in my report properties in Access?  Using version 2007.

thanks.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yes
0
 
Cole100Author Commented:
Sorry, but im not finding that option.
0
 
Jeffrey CoachmanMIS LiasonCommented:
I listed two places where this might be set, not just one.

The first is a manual pagebreak that you can see, that you will need to delete.
Here is a screenshot:

To check for the "Force new page" property:
Right click in each section of the report and select "Properties".
Click the "All" tab.
Locate the "Force new page" property.
(Are you saying that you cannot find this property on any of your report sections?)
As an example, here is another screenshot.

JeffCoachman
200.JPG
100.JPG
0
 
Cole100Author Commented:
Nice!  That got it.  Thanks for the details.
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now