Transferring Rich Text data from Access to Word

Question

I've been saddled with supporting an old Access 2003 database (with SQL backend) produced by a now out-of-business contractor.

The database includes several 'unconventional' reports. They all use Automation through VBA to output fields directly to a Word document. Kind of like this (pseudo code):

for each row{
      output(row.id);
      moveRight();
      output(row.firstName);
      newLine();
}

Etc.

The problem is, the database includes several rich text fields. To output these (including their formatting) to the document, the developer opens a separate Access form, with a single rich text control, and pulls the appropriate field into the text box.

He then does a 'select all, copy', flicks back to Word, and then pastes the text.

My task is to add a new rich text field to a report, and I feel there must be a better way of doing this...

It would be easier if he'd created a generic way of accessing the functionality. As it stands each report uses a slightly modified copy/ paste of the code. I'm struggling to be nice about this contractor's (Daily WTF-worthy) code. — ChristianLinnell, Apr 28 '09 at 02:48

score 1 · Accepted Answer · edited May 23 '17 at 12:19

1

Ah! A duplicate question apparently.

Here's the answer:

Word Automation: Write RTF text without going through clipboard

edited May 23 '17 at 12:19

Community

1
1

answered Apr 28 '09 at 03:32

ChristianLinnell

1,368
2
16
22

Transferring Rich Text data from Access to Word

1 Answers1