RE: [AccessDevelopers] TIME FORMAT

[George Oro]

Found out: nn:ss TY to JV.   Cheers, George   -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of George Oro Sent: Sunday, December 18, 2005 3:16 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] TIME FORMAT Thanks for your prompt reply Carl.   Actually I already tried several times "m:s" or "mm:ss" but no luck.       Dim myTime As Date     myTime = #12:30:00 AM#         Debug.Print Format(myTime, "mm:ss") - Return 12:00     Debug.Print Format(myTime, "m:s") - Return 12:0   Now I tried also:        Format(myTime, "30:00") - Return 30:00 But when my counter started, it gives me type mismatch error because it is already a text.     TIA George         -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Carl Beck Sent: Sunday, December 18, 2005 3:09 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] TIME FORMAT Have you tried  this   “(m:s)”   = Format(Now(), "h:m:s")  is used to auto fill a text box, I just tested       = Format(Now(), "m:s")        and got only minutes and seconds so it should work.   If you want it to read 30:00 then try “30:00”     Carl   From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of George Oro Sent: Sunday, December 18, 2005 5:47 AM To: YG Access Dev Subject: [AccessDevelopers] TIME FORMAT   Hi Group,   How can I format this time (12:30:00) that will appear only the minutes and seconds (30:00)? What format I have now is (00:30:00), basically I want to remove the two leading zero but still consider as time because I'm using this as a counter 30mnts to zero.   Any tips would be greatly appreciated.   TIA, George Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.