Need Code for Format for Minutes for a label

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
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
 
I want the format to be in minutes but the default should be 30000
Tried below, but did not work.

=Format([lblcounter],30000,"mm")
 
I want the format to be in minutes but the default should be 30000
Tried below, but did not work.

=Format([lblcounter],30000,"mm")
Click to expand...

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]
 
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")
Click to expand...

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]
Click to expand...
 
It suddenly occured to me: Change the timer refresh rate and that solved it.
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")
Click to expand...

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]
Click to expand...
Click to expand...
 
Back
Top