Short time display problem on form Lloyd 11/18/2008 9:33:01 PM I am using the "Short Time" format to display time in a 24 hour format but when I type in a time that starts with a zero (ie. 00:30) it does not display the first zero. Instead it displays 0:30 and not 00:30 as I would like. Any help?

Re: Short time display problem on form "Stuart McCall" <smccall[ at ]myunrealbox.com> 11/18/2008 10:29:13 PM "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message news:4D914331-3F64-4628-A0FD-5D6E78225116[ at ]microsoft.com... [Quoted Text] >I am using the "Short Time" format to display time in a 24 hour format but > when I type in a time that starts with a zero (ie. 00:30) it does not > display > the first zero. Instead it displays 0:30 and not 00:30 as I would like. > Any > help? Replace 'Short Time' with 'hh:nn'

Re: Short time display problem on form Lloyd 11/18/2008 10:51:01 PM I tried as you suggested but access 2007 changes hh:nn to "short date" and the problem continues. It wont allow hh:nn by itself. Another idea? "Stuart McCall" wrote: [Quoted Text] > "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message > news:4D914331-3F64-4628-A0FD-5D6E78225116[ at ]microsoft.com... > >I am using the "Short Time" format to display time in a 24 hour format but > > when I type in a time that starts with a zero (ie. 00:30) it does not > > display > > the first zero. Instead it displays 0:30 and not 00:30 as I would like. > > Any > > help? > > Replace 'Short Time' with 'hh:nn' > > >

Re: Short time display problem on form "Pete D." <pduffy211AT[ at ]coxDOT.net> 11/18/2008 11:59:22 PM Is it a properly formated text box? "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message news:D6524FBD-ECA5-47B0-B407-1E22B2AFC186[ at ]microsoft.com... [Quoted Text] >I tried as you suggested but access 2007 changes hh:nn to "short date" and > the problem continues. It wont allow hh:nn by itself. Another idea? > > "Stuart McCall" wrote: > >> "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message >> news:4D914331-3F64-4628-A0FD-5D6E78225116[ at ]microsoft.com... >> >I am using the "Short Time" format to display time in a 24 hour format >> >but >> > when I type in a time that starts with a zero (ie. 00:30) it does not >> > display >> > the first zero. Instead it displays 0:30 and not 00:30 as I would >> > like. >> > Any >> > help? >> >> Replace 'Short Time' with 'hh:nn' >> >> >>

Re: Short time display problem on form "Stuart McCall" <smccall[ at ]myunrealbox.com> 11/19/2008 12:01:45 AM "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message news:D6524FBD-ECA5-47B0-B407-1E22B2AFC186[ at ]microsoft.com... [Quoted Text] >I tried as you suggested but access 2007 changes hh:nn to "short date" and > the problem continues. It wont allow hh:nn by itself. Another idea? Try setting the property via code in the form's Load event: Me.TextboxName.Format = "hh:nn"

Re: Short time display problem on form "Jeff Boyce" <nonsense[ at ]nonsense.com> 11/19/2008 12:19:06 AM Lloyd I don't recall seeing anywhere that the underlying field on which you are attempting this is, in fact, an Access Date/Time field. Can you confirm this? Regards Jeff Boyce Microsoft Office/Access MVP "Lloyd" <Lloyd[ at ]discussions.microsoft.com> wrote in message news:4D914331-3F64-4628-A0FD-5D6E78225116[ at ]microsoft.com... [Quoted Text] >I am using the "Short Time" format to display time in a 24 hour format but > when I type in a time that starts with a zero (ie. 00:30) it does not > display > the first zero. Instead it displays 0:30 and not 00:30 as I would like. > Any > help?