Text Box data <-> Text file data

[Jael]

Using Access 2003, Vista Ultimate
I would like to link an unbound text box in a form to a text file in the
local directory. The text file is unique to the record being displayed in
the form. The name is
automatically generated and if it doesn't exist, a new "filename.txt" file
is created
in the local directory. Currently the data are entered in the text box and
using "After Update", the new data are appended to the text file.

Is there a way to directly link the two?

Appreciate any suggestions.
Thanks,

 

[Alex Dybenko]

Hi,
not sure that you can link it directly, but you can write some code to
read/write text file using Input# and Print#

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jael]

Thanks Alex,
That is the way I'm headed. I started using OpenTextStream, etc. but have
migrated to Input#/Print#

Jeff

 

[Jael]

Thanks Brendan,
Actually I'm trying to explore an alternative for Memo fileds. Nothing
against Memo fileds, just expanding my tool knowledge base.

Jeff