Solved

Access Export to RTF - Unwanted Paragraph Marks

Posted on 2004-04-29
3
889 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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

756 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