Set all values in a field back to zero. (0)

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

Guest

I need to change all the values in a field on a form (that is linked to a
query and tables) back to zero, in order to enter new data for the new year.

Is there a way to program this rather than having to scroll thru each record
and manually type the 0 into the field for each record?

I can't seem to get it right.
 
Another way is to set the DefaultValue property of the form's controls to
zero, which will put a zero in the controls as the value when you start a
new record.
 

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

Help with add leading zero to value 2
Change values back to zero 3
Zero Upload Speed 6
Set values back to zero 1
To Zero or not to Zero 5
conditionally setting field values to 0 3
Zeros Showing in Form Field 4
Change blanks to 0 (zero) 5

Back
Top