Time Formatting

[Sheldon]

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

Thanks

 

[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

 

[John Vinson]

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

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.

 

[Peter De Baets]

You can't do it with the Access format function. You'll have to create
your own time format using a string variable.

We have a free download that shows how to handle custom time formats.
More info is at this link: http://www.peterssoftware.com/ctf.htm

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com