Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-28
9
Medium Priority
?
298 Views
Last Modified: 2013-11-28
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
Comment
Question by:Cole100
  • 5
  • 4
9 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22828750
If this in fact a real page break, then why are the dashed lines needed at all?
0
 

Author Comment

by:Cole100
ID: 22832802
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22834002
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Cole100
ID: 22834955
Is this setting in my report properties in Access?  Using version 2007.

thanks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22836408
Yes
0
 

Author Comment

by:Cole100
ID: 22836551
Sorry, but im not finding that option.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 400 total points
ID: 22837356
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
 

Author Comment

by:Cole100
ID: 22838472
Nice!  That got it.  Thanks for the details.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22838600
;-)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question