Thanks, Tim but you should be telling Hee Lim,
I've used Transform() myself but it doesn't truncate trailing zeroes from fractions, as declared (see Fred Taylor's last message). Your approach looks promising. I was too busy to work something out similar for Hee Lim.
>I've always used Alltrim(Str(lnTimzNum,lnTotalLength,lnDecimalPlaces)) in my code previously. It allows you to specify the decimal places, however it is more strict than Transform() as it will only accept a numeric value
>
>I've been looking at some of the formatting things associated with Transform() now though. Maybe there's something in there which would help
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.