Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

GingerR (MIS)
18 Jan 05 14:00
I'm exporting a report to MS Word (rtf). The users will have to edit that frequently. However it seems when it converts to rtf, there's a paragraph mark at the end of every row of text, like this:

here's a pargraph of text that%
is one single paragraph so%
it won't wrap around%
when the user edits it.%
%
here's a second paragraph of text%
that the user also can't edit well.%
%

so when the user tries to edit, it doesn't wrap around like it would in a normal word doc. Anyone else ever have to deal with this? I need the paragraph marks within a paragraph to not exist, however some paragraph marks need to stay (header, in between paragraphs, etc)

Thanks--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

HitechUser (Programmer)
18 Jan 05 16:55
GingerR,

I could be wrong, but I do not believe the are "paragraph marks" they are simply CRLF (carriage return line feed).  Please see if these exist in you database field(s) you are using to populate the Word document.

Let me know...

                              

HitechUser (Programmer)
18 Jan 05 17:04

These are $chr(13) and $chr(10) respectivly.

RoyVidar (Instructor)
18 Jan 05 17:05
Oh, I believe, but have no explicit solution, except a "concept" - run a word macro that first replaces all single instances of enter with a space, then replace all instance of two spaces with one enter (perhaps the latter process on tree spaces first?)

Roy-Vidar

HitechUser (Programmer)
18 Jan 05 17:26
GingerR,

Can you tell me how you are creating this Word document??

GingerR (MIS)
18 Jan 05 21:56
Hi Roy--I was thinking of something similar...somehow designating the 'real' end of a paragraph with some funky character (in access, pre-export), then in Word replace all paragraph marks with a blank, then replace the funky character with a paragraph mark. That's the approach I'm working on, but it's pretty difficult right now. I have headers and other pieces of output that only have one paragraph mark - they are only one sentence, and there should really be a second paragraph mark after it (all the way to the left, to make a 'blank' sentence in between 'real' paragraphs) but the converter instead of making a second paragraph mark for 'blank' row between details, it makes the Paragraph setting in Word be like "6 above". yikes. I'm just going to keep playing with it.  

HitchUser--it's a regular Access report, no subreports or anything. A few headers. Some fields are MEMO and can be lots of words. I have a custom toolbar with a button that uses docmd.outputTo (rtf) that the user hits during PREVIEW of the report.

If I manually copy data from Access and paste it into Word, it's fine. No crazy paragraph marks.

Thanks--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

HitechUser (Programmer)
19 Jan 05 13:31
GingerR,

This sample may help.  It produces an exact duplicate of a report form into an RTF including graphics.  I do not know if it will help...

http://www.lebans.com/ReportUtilities.htm

Hey just a thought!!

GingerR (MIS)
19 Jan 05 13:57
Thanks for everyone's help. HitechUser--I've used the lebans one before, but it all comes out like one big graphic and isn't editable. Thanks though for the effort. I really appreciate everyone's ideas.

I was hoping for an easier solution, but since you guys mentioned the same idea I had, I concatenated a hopefully never-used-by-the-users character • (alt+0149) in the Access report wherever I want a paragraph mark to be when the doc is in it's final state. I took out all verticle spacing in the Access report and used the • instead. So the Access report looks bad: the bullet shows as a thick black rectangle and all the text is smashed up vertically so no vertical spacing (any spacing translates into changing the 'paragraph format' in MS Word to be like "6 pt above"). But I'll show the 'pretty' Access report to the Focal, then when they hit the button I'll export the 'ugly' one.

Then I added to an existing macro in MS Word (i record then tweak) that replaces all paragraphs (^p) with blanks, then replaces the bullets with paragraph marks. I also deleted all page breaks (^m) since the two Focals will be editing and those will get in the way. Now the final Word doc ends up with a single space (^p) between each paragraph, no paragraph marks at the end of each line of text, and in one big chunk (no page breaks) so the Focals can tweak it as they wish. They are happy and it takes them very little time to tweak it. The main jist of this exercise was that 50 users are entering their info into the db now instead of submitting multiple different MS Word docs to the two Focals in mulitple diff formats for the focals to compile and sweat over.

Now I just have to hope no one ever uses alt+0149 :)

Thanks again--g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close