countdown 2 digits

[rwahdan1978]

Hi

I have a countdown counter in my form from 30 to 0:

        Label2.Visible = True
        Label3.Visible = True
        txtTimer.Visible = True
        Me.Command5.Enabled = True
        Me.txtTimer.Value = Me.txtTimer.Value - 1
        If Me.txtTimer.Value = 0 Then
            DoCmd.OpenQuery "updateAhmad"
        End If

it is fine and goes from 30 to 0 but when it reaches 9 it is showing as one digit and i want it to show 2 digits.


instead of 30,29,28...10,9,8,7...
I want 30,29,28...10,09,08,07...

[Micron]

Try Me.txtTimer = Format(Me.txtTimer - 1,"00")
As long as you don't need to use the value in any sorting or math you should be OK.