Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting report, with subreports, to Word causes text to mix. 1

Status
Not open for further replies.

AtlasAF

Programmer
Feb 7, 2005
59
US
I am trying to export a report, that contains three subreports, to word using the default export function in Access 2007. Once the export completes, the text from the fields that are set to grow end up mixed together. When the report is viewed using Print Preview everything looks correct. This only appears in the Word product. It appears as if the fields are growing but not changing position on the page.

I have considered doing this report uses a Mail Merge but decided it would be better to use the export feature due to the multiple tables and querys the report has to reference. There are no graphics to export it is just text with some bolding and underlining so the .rtf format should work fine with this report. Any help would be appriciated.

AtlasAF
USAF
 
To docuement a resolution with this thread:

I figured out a way to fix this mixing.

The main report only opens one record based on what is currently displayed on the form. I created a grouping in the report based on the record id field. I moved the subreports to the details section of the grouping and the other fields to the grouping header. Doing so removed the mixing and produced a usable product in word.

I hope this helps others in the future.

AtlasAF
USAF
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top