memo field to .txt file

[LeeTV]

does anyone know how to make the contents of a memo field be saved in a .txt
file?
(how is this done in VBA).
TIA.
Lee

 

[Daniel Pineault]

You can use the WrieTxt() function found at

http://www.devhut.net/index.php?lang=en&id=0000000027#WriteExtFile

and thensimply pass it the memo field value along with the filepath/filename
to write to.

WriteTxt("C:\MyfileName.txt", Me.MemoFieldName)
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.