format number without rounding?

[DahMurf]

I'm using the following to change the format of a numeric field:

formatspeed = Format(cr.Speed, "###.000&quot

The data, for example, is 123.4567. I'd like to end up with 123.456. I want to drop anything beyond the 3rd decimal but I do not want to round. How can I do this without rounding?
I need to maintain the full length field in my from table but reduce the length for my to table.

Tia for any help!

 

[DahMurf]

I found it! A little more digging in this forum netted this:

formatspd1 = (Int(cr.Speed * 1000) / 1000)

Works like a champ! Great forum, thanks!