How do I write to a text file with no carriage returns??
I have Tried :

Replace("fieldname", vbCRLf,"")
Replace("fieldname",char(13) & char(10),"")


Both of them don't work

remove the quotes from around fieldname

I tried that and it did not work

Here is the code:

Private Sub Command41_Click()
Open "c:\text.txt" For Append As #1



Write #1, Replace(Me.UCC, vbCrLf, "")




Close #1
End Sub

Don't know if this hopefully might help somehow:

FileSystemObject
http://www.4guysfromrolla.com/webtec...leSystemObject

The Wonders of the File System Object by Chris Payne - 8/16/2000
http://www.15seconds.com/Issue/000816.htm