Solved

Access Export to RTF - Unwanted Paragraph Marks

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

705 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

18 Experts available now in Live!

Get 1:1 Help Now