Default Value not passing to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brennan - 13 May 2008 14:37 GMT

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

Reply to this Message

Klatuu - 13 May 2008 14:53 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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.
[quoted text clipped - 3 lines]
>
> Brennan

Reply to this Message