Currency field with Decimal

[mohsinof]

I have a problem with access field which currency type I have put it as 3 decimal, when I type something like 1.655 it works fine and save it the same like 1.655 in the table but when I type 1.500 it saves only 1.5 in the table is there away to save it like 1.500 and show 00??

Thanks in advance.

[techyspecy]

Originally posted by mohsinof
I have a problem with access field which currency type I have put it as 3 decimal, when I type something like 1.655 it works fine and save it the same like 1.655 in the table but when I type 1.500 it saves only 1.5 in the table is there away to save it like 1.500 and show 00??

Thanks in advance.

Yeah, use string instead of currency ...

[mohsinof]

Yeah, use string instead of currency

But there is no string data type in access ??!!

[mohsinof]

I tried to but in my vb code

Format(x,"0.000")

Where x is the value

but still is shows 1.5 instead of 1.500 , it doesn't shows only the last two zero but when I type 3.355 it shows the three decimal places 3.355 !!

Any further help??

[mxnmx]

I think:
Change your MS ACCESS field from Currency to Text

And

Format(x,"0.000")

You know the field in Access is set to currency so whatever you save there will be saved as its saving now. So change it to Text and then use the code above. It shd work all well!!!

[mohsinof]

But I would like to make calculation on that field like

Currency_Field *0.5

if it is text it will not calculate??

Thanks again

[mxnmx]

If you wish to perform calculations you can do this:

Currency_Field * Val(Text1.Text) 'This will convert string to integer data type...so that you can perform calculations...