display milliseconds

D

Douglas J. Steele

Not reliably. Date/Times are stored as 8 byte floating point numbers (where
the integer portion represents the date as the number of days relative to 30
Dec, 1899, and the decimal portion represents the time as a fraction of a
day). Due to floating point accuracy issues, I believe you can only get
about 3 millisecond accuracy these days.
 
D

david epsom dot com dot au

There is no Format type for milliseconds. You would
have to multiply by 24*60*60*1000 to get milliseconds.

The Date,Time and Now functions in VBA use the BIOS
timer, not the Multi-Media timer or the high-resolution
timer, so you won't get good millisecond data unless
you use calls to the Windows API or to hardware.

And Jet/VB Time fields are stored as floating point
numbers, so the resolution decreases as the interval
get larger. You won't be able to store good millisecond
data in a time field if you also include the date in
the same field.

(david)
 
Top