I have a database with a memo field called 'Description' and am automating Word to edit it. The App is in a class module with events, and the ID for the record whose description is being edited is stored in a document variable, and the RecorsetClone of the Forn that invoked Word is a property of the class module. When the Document is saved, the DocumentBeforeSave event handler looks up the ID and does
a
RecSet.Edit
RecSet![Description] = Doc.Content.Text
RecSet.Update
the problem is that the newly edited record is displayed in the Form's testbox with missing CRLFs, but if I load it back into Word the formatting is fine. Does Word use a different delimiter? I could probably live with this but being able to display the Description properly on a Form is important... what am I missing?
Start Free Trial