How to determine if a currency value has cents

[ElPresidente]

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

 

[Steve Schapel]

ElPresidente,

[YourCurrencyField]>Int([YourCurrencyField])

 

[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

 

[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