Edit rtf memo field in Word

[dbones202]

I am building a database application, in which the users desire to use Word to Edit and change the RTF memo field of a particular table. I know how dump access rtf information to Word. Is there a way anyone can think of to pull it all back from the word application? Maybe some way to create a submit/close button that sends the data back?

[NTC]

perhaps with a single record, single field; you could try and export/import approach.....

in general Word is not sufficiently structured....but if there is just one field perhaps it might work....

[dbones202]

All that I am trying to edit is one field of a single record at a time. The users are strongly desirous to have Words spelling and grammar check run on this field and as such it would be easiest to have the field edited within Word.

It has been suggested that perhaps Access could use VBA to open Word (plenty of examples out on the web for that) and export the information of a single field of a single record to Word (again lots of web pages out there for that.) Then use VBA to pull the information back in when the user closes Word, with a OnClose script within VBA for Word.

The other idea is that a button could be made in word to cut and paste the field to Word and back. I haven't had time to try these but will be attempting them this next week.