Delete .txt file if file size = 0

[John]

In access,I create a .txt file in a certain folder. Is there a way in code
to look at that folder and if the .txt file is a 0 length text file to delete
it.

Thanks,
John

 

[Marshall Barton]

In access,I create a .txt file in a certain folder. Is there a way in code
to look at that folder and if the .txt file is a 0 length text file to delete
it.

Use the FileLen function

 

[Rob Oldfield]

Function FSize()
Dim fs, f
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("c:\xx.txt")
FSize = f.Size
End Function

....though it'd be more efficient to check, when creating the file, if
there's any data. If there isn't, don't create the file.