Overriding default QUOTING of text fields with WRITE 1

[WildHare]

Hi gang - have a process which writes text and numbers to a text file for another outside piece of software to grab and display on a large plasma TV screen.

The process works except for the fact that Acces/VB(A) surrounds all TEXT strings written to a file with Quotes, e.g.

"Joe"
"Blow"
1234

The other program chokes on the quotes. Short of editing the text file and doing a Find/Replace on " to NULL, does anyone know if there is an Access or VB setting or registry hack that can be done to override the quoting, so I can just write

Joe
Blow
1234

Example of the code:

Write #1, Fname
Write #1, Lname
Write #1, Account

Much Thanks In Advance for any suggestions...

Jim

Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[PHV]

HAve you tried to play with the Print # instruction instead of Write # ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

Hi!

Had same problem a while back, and started using the filesystemobject. Here's one thread demonstrating some of the methods thread705-778800.

Roy-Vidar

 

[WildHare]

PHV, the PRINT did the trick..don't know why I didn't think if trying that.. then again, this job is turning my brain to mush....

Thanks again..

Jim

Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm