Syntax To Insert A Number Into One TrxtBox If A Different TextBox Has A Date That Is = 1/1/98
Greetings,
In an Exit event I need to see if the date value in TextBox1 is =
9/15/1998. If yes, then the value in TextBox 7 needs to be .0825. If
not, the value in TextBox7 needs to be.08.
I tried this:
If TextBox1.Value = "9/15/1998" Then
TextBox7.Value = "8.25%"
Else:
TextBox7.Value = "8%"
End If
But it only returns .0825 in TextBos7, no matter what the date is in
TextBox1.
What am I doing wrong?
Can anyone help me?
TIA
-Minitman
|