I need to prevent editing of a field after the record has been saved. The analyst wishes to accomplish this by doing a check when the record is saved, and then display a message.
So, I did this:
If Not frmMe.NewRecord Then
If (TStr(frmMe!txtTestId.OldValue) <> TStr(frmMe!txtTestId)) Then
Msg_Err GetStringConst("Test", 280)
Cancel = True
The problem is, this check does not recognize that the value is different if you simply change the case of the value.
In other words, if txtTestId.OldValue is "DEF", and I change the value of txtTestId to "def", the two values are interpreted as equal, so the message does not display.
How do I make this check case-sensitive?