D
Dave Elliott
I have a label that counts down in seconds, I need the format to be in
minutes
it is an unbound control with it's default set to 30
minutes
it is an unbound control with it's default set to 30
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Elliott
I want the format to be in minutes but the default should be 30000
Tried below, but did not work.
=Format([lblcounter],30000,"mm")
Tried below, but did not work.
=Format([lblcounter],30000,"mm")
J
John Vinson
I want the format to be in minutes but the default should be 30000
Tried below, but did not work.
=Format([lblcounter],30000,"mm")
mm is Months (nn is miNutes) - and the Format function takes *two*
values not three.
If the countdown is in seconds, and the starting value is half a
minute - what exactly are you asking? What do you want to see on the
label? 00 for thirty seconds and then 00???
John W. Vinson[MVP]
D
Dave Elliott
The default is 30000 for the lblcounter
Then it counts down to zero and other code runs.
It is counting by seconds rather than minutes on the control lblcounter
I would like it to show minutes instead if possible.
Do I change the format? right now it has no control source or format, just a
default value of 30000
Me!lblcounter.Value = Me!lblcounter.Value - 1
If Me.lblcounter = 0 Then
DoCmd.Quit
End If
Then it counts down to zero and other code runs.
It is counting by seconds rather than minutes on the control lblcounter
I would like it to show minutes instead if possible.
Do I change the format? right now it has no control source or format, just a
default value of 30000
Me!lblcounter.Value = Me!lblcounter.Value - 1
If Me.lblcounter = 0 Then
DoCmd.Quit
End If
John Vinson said:I want the format to be in minutes but the default should be 30000
Tried below, but did not work.
=Format([lblcounter],30000,"mm")
mm is Months (nn is miNutes) - and the Format function takes *two*
values not three.
If the countdown is in seconds, and the starting value is half a
minute - what exactly are you asking? What do you want to see on the
label? 00 for thirty seconds and then 00???
John W. Vinson[MVP]
D
Dave Elliott
It suddenly occured to me: Change the timer refresh rate and that solved it.
Thanks,,,,,,
Thanks,,,,,,
Dave Elliott said:The default is 30000 for the lblcounter
Then it counts down to zero and other code runs.
It is counting by seconds rather than minutes on the control lblcounter
I would like it to show minutes instead if possible.
Do I change the format? right now it has no control source or format, just
a default value of 30000
Me!lblcounter.Value = Me!lblcounter.Value - 1
If Me.lblcounter = 0 Then
DoCmd.Quit
End If
John Vinson said:I want the format to be in minutes but the default should be 30000
Tried below, but did not work.
=Format([lblcounter],30000,"mm")
mm is Months (nn is miNutes) - and the Format function takes *two*
values not three.
If the countdown is in seconds, and the starting value is half a
minute - what exactly are you asking? What do you want to see on the
label? 00 for thirty seconds and then 00???
John W. Vinson[MVP]