Access Export to RTF - Unwanted Paragraph Marks

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
Ronda-SAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
nico5038Connect With a Mentor Commented:
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
 
Ronda-SAuthor Commented:
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
 
nico5038Commented:
Glad I could help.

Success with the application !

Nic;o)
0
All Courses

From novice to tech pro — start learning today.