Copy content of file.txt into Me.memofield on Access Form 1

[KUZZ]

I am trying at the push of a button on an Access form to copy contents of simple text file "c:\file.txt" into a memo field "memo" on the same Access form. Has anyone done this before? Please help.

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."

 

[Remou]

This may suit:

Set fs = CreateObject("Scripting.FileSystemObject")
Set strFile = fs.OpenTextFile("Document1.txt", 1)
strText = strFile.ReadAll
Me.txtMemo = strText
strFile.Close

 

[KUZZ]

Thanks for the tip, worked like a charm.

Good luck,
Kuzz

"Time spent debating the impossible subtracts from the time during which you
can try to accomplish it."