Storing Rich Text and using in Access and Word



Hi All

I am using Access 2000 and MS Word 2003

I have a database where I store information in Memo fields and then
during a comlplex report generation process it writes information to a
word document.

My client now wants to add formatting (bullets and hyperlinks etc.) to
some of the text stored in the memo field in the access database.

I can go into word and edit the text as needed, save as RTF and copy
and paste that information back into my access database. I do not
have a need to actually edit the RTF inside of my access database - I
am cofident that what I copy and paste from my RTF editori (notepad)
that I can get the correct RTF into the database

My question is how can I get that RTF back in to word during my report
process - currently I simply read the text from the field and drop it
into word in the correct place as needed - I would like to be able to
do something similar with Rich Text so that the formatting gets put
into word as well

Any thoughts on this please let me know

Thanks for your assistance

Jeff

If you think I should post in a different group instead please let me
know

.



Relevant Pages

  • Re: text parsing
    ... I want to take a bunch of text files (rtf), read them in and dump the ... What would the target database be -- MySQL? ... A bunch is about a dozen. ... My goal is to create a encounter generation program - where I key in climate, geography, season, encounter level, time of day, proximity to civilization, and the application gives me a suggested random encounter suited to the scenario. ...
    (comp.lang.php)
  • Re: text parsing
    ... What would the target database be -- MySQL? ... A bunch is about a dozen. ... Any chance the RTF files are online so I could look at them? ... Using those 86 RTF files it created a 10MB MS-Access database. ...
    (comp.lang.php)
  • Re: text parsing
    ... I want to take a bunch of text files (rtf), read them in and dump the ... What would the target database be -- MySQL? ... A bunch is about a dozen. ... My goal is to create a encounter generation program - where I key in climate, geography, season, encounter level, time of day, proximity to civilization, and the application gives me a suggested random encounter suited to the scenario. ...
    (comp.lang.php)
  • Re: Export Project notes to Access or Excel
    ... I was able to get the RTF by casting the column to varchar. ... from a Project database file to jdpeterson, ... What I do have however is a VBA macro ... I don't have a database server, ...
    (microsoft.public.project)
  • Re: text parsing
    ... What would the target database be -- MySQL? ... Any chance the RTF files are online so I could look at them? ... climate, geography, season, encounter level, time of day, proximity to ... "Monster" rtfs converted to HTML and made available via ...
    (comp.lang.php)