J
JD McLeod
I have an Access database that our offices uses to generate audit reports.
The
reports are downloaded into an .rtf format and then saved as a Word document
and sent to our word processing department for finalization. The WP folks
add some special formatting and graphics that are too complicated for us to
do in Access. When the reports are opened in Word, we have found that there
is an extra space at the end of each line (line, not sentence). All other
words have one space between them and each sentence end has two spaces after
it (that's how our boss wants it, with two spaces). Other than using a find
and replace in Word (find " " " " and replace " "), is there a quicker or
easier way to fix this in access? The field is a memo field type. I have
not had any other problems such as the data being chopped off or anything
like that, just the addition of the extra space at the end of each line. I
am also posting this question in the Word community to see if there is a fix
in Word that I'm not aware of. Thanks.
The
reports are downloaded into an .rtf format and then saved as a Word document
and sent to our word processing department for finalization. The WP folks
add some special formatting and graphics that are too complicated for us to
do in Access. When the reports are opened in Word, we have found that there
is an extra space at the end of each line (line, not sentence). All other
words have one space between them and each sentence end has two spaces after
it (that's how our boss wants it, with two spaces). Other than using a find
and replace in Word (find " " " " and replace " "), is there a quicker or
easier way to fix this in access? The field is a memo field type. I have
not had any other problems such as the data being chopped off or anything
like that, just the addition of the extra space at the end of each line. I
am also posting this question in the Word community to see if there is a fix
in Word that I'm not aware of. Thanks.