View Single Post
 
Old February 16th, 2005, 09:04 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Try parsing this with Split() instead of colon, like this:

'==========
If IsNull(Me.tbxYourTextBox) Then
   stTime = "00:00:000"
   Else: stTime = Me.tbxYourTextBox
End If

TimeArray = Split(stTime, ":")
   stMin = TimeArray(0)
   stSec = TimeArray(1)
   stMls = TimeArray(2)
stStoredValue = stMin & "mn. " & stSec & "sec. " & stMls & "mls."
'==========

   You may need to add error handling for missed milliseconds, etc.

HTH.



mmcdonal