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), " ")
Here's the SQL in my Query:
SELECT venues.Region, venues.VenueName, fncReplace(vdescription) AS MemoNoPara
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):
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.
Thanks a bunch.