Link to home
Start Free TrialLog in
Avatar of Cole100
Cole100Flag for United States of America

asked on

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?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

If this in fact a real page break, then why are the dashed lines needed at all?
Avatar of Cole100

ASKER

They are not needed.  I would like to avoid the page breaks.  When trying to print this document i get 1 record per page.
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
Avatar of Cole100

ASKER

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

thanks.
Avatar of Cole100

ASKER

Sorry, but im not finding that option.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Cole100

ASKER

Nice!  That got it.  Thanks for the details.