How to determine if a currency value has cents

E

ElPresidente

Everything I can think of uses strings and Access keeps dropping any
trailing 0s when converting to string. Any ideas?
 
D

Dominic Vella

I think you could use the format command, eg [strNew] = Format([curOld],
"0.00")

I am doing this from the top of my head so I'd suggest you check the
Format() command using your help files before using it.


Dom
 
E

ElPresidente

Thanks everyone.

It was getting late in the day. I ended up using the round function
and diving by itself to determine if there was a decimal
 
Top