Is there an acceptable string literal in the VBA (Access 2013) TimeValue function to express fractions of a second?
In this particular case a Half-Second.
TU_HALF_SECOND = TimeValue("00:00:00.5") ' Type mismatch error
As a work-around I have calculated it mathematically from a value of one-second:
TU_HALF_SECOND = TimeValue("00:00:01") ' The smallest (non-zero) literal I have found that works
TUVal_HALF_SECOND = CDbl(TU_HALF_SECOND)
TUVal_HALF_SECOND = TUVal_ZERO_SECONDS + (TUVal_HALF_SECOND - TUVal_ZERO_SECONDS) / 2
' Zero seconds obtained via TimeValue("00:00:00") :: I'm aware that this may be redundant
TU_HALF_SECOND = CDate(TUVal_HALF_SECOND)
So this is not an emergency, I'm just curious.