Solved

Access Export to RTF - Unwanted Paragraph Marks

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now