Removing a negative sign from a number

[Gibson]

I am using the following code to place a number in a text file. I open up
the file, find the data and print it to the file. The problem is if the
number is negative the first character in the field of the text file is the
negative sign (-). Is there a way to convert the number so the number
printed to the text file does not have the negative sign in front of it? I
tried the CStr function but the sign still appears.

(Format(rs!Num * 10000, "000000000000000")

 

[Ken Snell [MVP]]

Use the Abs function to remove negative signs:

(Format(Abs(rs!Num) * 10000, "000000000000000")