My minutes box doesnt show the leading zero

[Rob the amateur]

I have created a table with seperate entries for hours and minutes, which
default at the current time. However, the minutes box displays the time as a
single digit if there is a leading zero, so that when i combind the boxes
later, it looks odd, eg, 15:7 instead of 15:07.

So, is it possible to get the table to automatically add the leading zero?
I am working on Access 2003.

 

[John Vinson]

I have created a table with seperate entries for hours and minutes, which
default at the current time. However, the minutes box displays the time as a
single digit if there is a leading zero, so that when i combind the boxes
later, it looks odd, eg, 15:7 instead of 15:07.

So, is it possible to get the table to automatically add the leading zero?
I am working on Access 2003.

You can use the Format() function in combining them:

=[Hours] & Format([Minutes], "\:00")


John W. Vinson[MVP]

 

[Tim Ferguson]

=?Utf-8?B?Um9iIHRoZSBhbWF0ZXVy?=

However, the minutes box displays the time as a
single digit if there is a leading zero, so that when i combind the
boxes later, it looks odd, eg, 15:7 instead of 15:07.

you can put them both into one textbox by putting something like this in
the controlsource:

=Format([ElapsedMins],"00") & Format([ElapsedSecs],"\:00")

or you can put them into two text boxes each with the Format property set
to "00"

You could even just have one field for ElapsedSecs and display it like
this:

=Format([ElapsedSecs]\60,"00") & Format([ElapsedSecs] mod 60, "\:00")

Hope that helps


Tim F