Number to text Problem

[bbrendan]

Hi Im need some help here!!

I have a number field in access
for example

12.99

and I want to convert this to text

0000000001299

I have used this:

Format([amt_payment],"000000000000")

But I get it rounded up to

0000000000013

any ideas??

thanks
brendan

 

[Newman]

CStr(Format([amt_payment],"000000000000"))

 

[bbrendan]

Hi Newman,

that works fine. Except If I have a number like

10.00 or 2.00

then it just shows up as #Error

cheers

 

[RV]

How about this;

CStr(Format([100*amt_payment],"000000000000"))

RV

 

[bbrendan]

Hi RV,

that seems to have nailed it..

thanks to both of you