One more idea. Trap the delete key at textbox level. If user place Delete, replace the value with NULL. I would suggest to subclass regular texbox and use it everywhere.
>Jayesh,
>
>Thanks for your quick reply to my posting. Couldn't have been more than a minute or two!
>
>I thought of the Ctrl-0 strategy, but that isn't good because it requires the user to do something unusual. "Doesn't delete mean delete??" So, I couldn't be confident that they would always do the right thing.
>
>The second strategy of just replacing zero values with .NULL before sending it to the table won't work either because 0.0 is valid data. Maybe the user really wants the value to be 0.0.
>
>I was hoping that I could end up with something quite automatic, much like it is now, i.e. bind the textbox to the field and it gets automatically updated.
>
>Any thoughts along that line?
>
>Jim
- Jayesh