I have some textboxes that display values from a table. The type of these values is double. The default value is .NULL.

As expected, when I create a blank record, these values are initialized in the table to .NULL.

When the user enters a number into the textboxes, the table values get updated appropriately, i.e. the table value becomes that number.

However, if a user now selects that textbox and deletes its contents, the table value does not revert to .NULL., but instead becomes the value 0.0. This is not correct.

What is the best way to have the table value go back to .NULL. when the user deletes the value from a textbox bound to that table field?

Thanks,
Jim