Time Formatting

S

Sheldon

Using Format(Now(), ".....") how do I format the time part
to include tenths, or hundreds or thousands of a second?

Thanks
 
R

Rick B

I do not believe that Access tracks time to that level.

Rick B

Using Format(Now(), ".....") how do I format the time part
to include tenths, or hundreds or thousands of a second?

Thanks
 
J

John Vinson

Using Format(Now(), ".....") how do I format the time part
to include tenths, or hundreds or thousands of a second?
Click to expand...

You can't, not using a Date/Time field. One second is the finest
resolution available.

If you wish to store durations, I'd suggest using a Double or Float
number, storing seconds and fractions of a second. You'll need some
formatting code to display hours and minutes.
 
Top