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