Greetings ~
I am trying to create a Boolean condition with the value of a textbox which has its value expressed in "hh:mm:ss" format.
Below is the conditional statement which simply will not read correctly
The current value of TextBox 74 is 21:16 and yet it blows right past the 'then' and onto the 'Else'
Help??
Thank You ~
I am trying to create a Boolean condition with the value of a textbox which has its value expressed in "hh:mm:ss" format.
Below is the conditional statement which simply will not read correctly
Code:
If Format(.TextBox74.Text, "hh:mm:ss") > "3:00" Then
.TextBox74.BackColor = vbGreen
Else: .TextBox74.BackColor = vbRed
End If
The current value of TextBox 74 is 21:16 and yet it blows right past the 'then' and onto the 'Else'
Help??
Thank You ~