I've got a data entry form with databindings on the text property to members of a dataset. I then use a Currency Manager to add or edit. There is also some simple validation on the textbox Validating event and an Error Provider.

Everything is fine for strings (nvarchars column in SQL Server) in the textboxes. But with Integer/Int32 (int column in SQL Server) there is very strange behaviour:
1. Delete the textbox entry (allowed) and move elsewhere (by keyboard or mouse) and the number miraculously reappears!
2. Enter something invalid (e.g. alphabetic) move off the textbox and again the original number returns!

Contents of the textbox are ok just prior to ending the Validating code. But contents have changed back when in the Validated event. Almost like a Currency Manager EndCurrentEdit.

(VS.NET 2005 Beta and SQL Server Express 2005).

Just can't work it out. Any ideas out there?
zapo