Default Value not passing to table

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

I have a form that pulls the values of text boxes into a table - pretty
standard. My trouble is that it won't pull the zero values into the table.
I have the text boxes set to display a "0" value when nothing is entered in,
but those aren't making it to the table. Null values are in the table.
Could someone provide some advice? Thanks

Brennan
 
The Default Value property only applies the value specified to newly added
records. It will not change a null value in an existing record. If you have
existing records with null values you want to change to zero, you need to use
an update query to fix your data.
 
Back
Top