Add property Oldvalue to the base class of your textbox and set it to the THis.Value in the GetFocus. In the Validate event check This.Value against This.OldValue.
>In a text box on a form I am trying to put code in the valid event to prompt the user that if this field value changes then another field value will change so in the valid event I put "IF OLDVAL("{fieldname}","{tablename}") !=this.value
>" then prompt user of additional change. This works fine until the user clicks into the same field a second time does not change the value and gets the same message, which I am trying to prevent. I am using Optimistic row buffering so unless I commit my changes on the initial change, which I don't want to do, I continuously get the prompt for the change in value of the field. Any ideas?
>
>Thanks for your help!
>Stephen J. Hunt
--sb--