I believe that TRANSFORM() is affected by SET DECIMALS. You probably have it a 2 (the default) and that is all it will recognize for the numeric arguement.
>Dear all,
>
>I have a question about the Transform function:
>
>transform(0.001,'9.999') returns '0.000'
>
>
>which I expect it to return '0.001'.
>
>Any idea of where does it go wrong? I am using VFP9 SP2.
>
>Thanks,
>David