L LeeTV Apr 8, 2009 #1 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
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
D Daniel Pineault Apr 8, 2009 #2 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.
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.
