Solved

Access Export to RTF - Unwanted Paragraph Marks

Posted on 2004-04-29
3
890 Views
Last Modified: 2008-03-10
I have a report that has a memo field with one or more paragraphs in it.  The problem is that when this report gets exported to Word, each LINE has a paragraph mark at the end of it, instead of a paragraph mark being placed just at the end of each paragraph.

I tried using a function to remove the CR/LF that gets added when a report exports out to Word using the Officelinks or the OutputTo command.


Here's what my function looks like (it's in its own module):
_________________________________________________________
Option Compare Database

Function fncReplace(strmemo As Variant) As Variant

    fncReplace = Replace(strmemo, Chr(13), " ")
    fncReplace = Replace(fncReplace, Chr(10), " ")
End Function
_________________________________________________________

Here's the SQL in my Query:

SELECT venues.Region, venues.VenueName, fncReplace(vdescription) AS MemoNoPara
FROM venues
WHERE (((venues.VDescription) Is Not Null));
_________________________________________________________

I then created a report that has three fields in the detail section just like this (no report or page header/footer):
Region
VenueName
MemoNoPara

I have the shrink/grow properties both set to YES for each field and for the detail section.

When I export the report using OfficeLinks, I still get the paragraph marks at the end of each line.

Ugh.

Any ideas??

Thanks a bunch.

Ronda
0
Comment
Question by:Ronda-S
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 500 total points
ID: 10951777
Hmm, I ran into the problem that the Access export to MS Word inserts the unwanted paragraph marks.
Besides using automation to put the data directly into MS Word I see no other option to get a clean MS Word document.

When more formatting as just those three fields is needed, perhaps a mailmerge or automation using a template can offer relief for this problem.

Nic;o)
0
 

Author Comment

by:Ronda-S
ID: 10953016
Thank you Thank you Thank you for showing me the automation to put the data into Word... I've done a bit of that with Excel, but never with Word.

Couldn't have solved this without you!

:-)  Ronda
0
 
LVL 54

Expert Comment

by:nico5038
ID: 10953133
Glad I could help.

Success with the application !

Nic;o)
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

752 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