title: Access Default Value Giving #Size! Error
body: <p>I am using an Access 2013 form for calculations.  I have a user inputting the hours they work in a text box for each day of the week.  Labeled accordingly txtMonday, txtTuesday etc.  I have a text box for all the hours worked txtTotalHours which I am setting the default value for with this formula <code>=NZ(txtMonday,0)+NZ(txtTuesday,0)+NZ(txtWednesday,0)+NZ(txtThursday,0)+NZ(txtFriday,0)+NZ(txtSaturday,0)+NZ(txtSunday,0)</code> this presents an error of <code>#Size!</code> </p>
  
  <p>I thought the <code>NZ()</code> would account for any issues, but I still get an error.  What can I do to overcome this error and have my calculation show a 0 if all the days are zero or null or blank, OR the SUM if the days have a value input?</p>