Defaults values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set a default value of zero in a series of numeric fields, but it is not
appearing in the corresponding fields on the form. Any idea why this would
be? Thanks!
 
I set a default value of zero in a series of numeric fields, but it is not
appearing in the corresponding fields on the form. Any idea why this would
be? Thanks!
Click to expand...

The Default only applies at the time a new record is added. If you
apply a default to a field with existing NULL values, those values
will not be changed. Is that what's happening?

John W. Vinson[MVP]
 
That's exactly it!! Thanks much. Once I "filled in the zeros", the totals
box auto-filled as expected. Appreciate the assistance, John!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating averages on a form 3
Define a default value from a different form 9
Sub Form Default Values 4
change default value in table field - Easy for user 4
Zero fill numeric field 1
Default Data in table view 4
Calculated Controls Nz IIf 7
Default Value as last date in a table? 5

Back
Top