[AccessD] TransferText Failling

Seth Galitzer sgsax at ksu.edu
Mon Mar 10 16:26:01 CST 2003


Jim,

Try putting 
	On Error Resume Next
right before the Kill statement, and then
	On Error GoTo <error handler label>
right after to re-enable your error handler.

As for your formatting, have you tried looking in Help for User-Defined
Number Formats?  If you do, you'll see that the # character will display
a digit or nothing.  What you want to use is the 0 character, which will
display a digit or a zero.  So when you format your text for printing,
you want to use
	Format(<fieldname or string>, "-0000.00")

Hope this helps!  Happy exporting!

Seth

On Mon, 2003-03-10 at 16:12, Hale, Jim wrote:
> Seth,
> I happened to be writing a little routine to dump plan data to a text file
> so the mention of your code was very timely. Thanks! several comments: If
> the file doesn't exist the killfile line gives an error. I added a filexists
> test. Second 
> "Open strOutfile For Binary As intFileDesc" doesn't seem to work with the
> Print statement. I changed binary to Append and the code works. 
> 
> I need my amount field in the text file formatted as "-####.##" but -2000.00
> is printed as -2000; 2000.20 is printed as 2000.2, etc. How can this be
> correctly formatted in the print statement?
> Regards,
> Jim Hale
> 

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University




More information about the AccessD mailing list