Import WordPad RTF file into an RTF Memo field in Access 2007

  • Thread starter Thread starter genojoe
  • Start date Start date
G

genojoe

I would like to import and export RTF documents into a table memo field that
supports RTF using code. For exporting text, I use the following

sFile = "c:\temp\EmailsSent.txt"
sText = Now & " is the date sent."
Dim a As Object
Dim fs As Object
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.OpenTextFile(sFile, 8, False)
a.WriteLine (sText)
a.Close

Is there similar code that I can use to transfer the contents of an RTF memo
field in a table to and from an RTF file?
 
I would like to import and export RTF documents into a table memo field
that supports RTF using code. For exporting text, I use the following

sFile = "c:\temp\EmailsSent.txt"
sText = Now & " is the date sent."
Dim a As Object
Dim fs As Object
Set fs = CreateObject("Scripting.FileSystemObject") Set a =
fs.OpenTextFile(sFile, 8, False) a.WriteLine (sText)
a.Close

Is there similar code that I can use to transfer the contents of an RTF
memo field in a table to and from an RTF file?
Click to expand...

If you are talking about the new "rich text" feature in Access 2007 I
think you will have problems because it is actually HTML, not "real" rich
text.
 
Back
Top