Null Value

  • Thread starter Thread starter Nathan Carroll
  • Start date Start date
N

Nathan Carroll

I have a field in Access db that I want to allow empty or null value. The
field in question is a double. If the field contains a value when I load
the dataset I am unable to empty or null it. The field in question is
melting point of a chemicals; so you can see the pertinence of allowing
null. The same database with access forms allows me to delete a value.
 
You haven't given enough info or code to provide you a specific answer.
However, in general, you would set the field equal to DBNull.Value.

--Bob
 
How do I implement dbnull.value? Do I have to set it in the datatable?

this worked but is it best procedure
Private Sub MeltingPointF_Leave(ByVal sender As Object, ByVal e As
System.EventArgs) Handles MeltingPointF.Leave
If Me.MeltingPointF.Text = "" Then
MyData.Table.Rows.Item(bm.Position)("MeltingPointF") = DBNull.Value
End Sub
 
why don't you try replacing nulls with a blank value from your sql statement
using the replace key word
 
Back
Top