zero in numeric fields

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

Guest

I have a multi-page form, with multiple different field types entered,
including yes/no, date/time, text, number, and comboboxes.

If you tab through the fields everything is fine, but since many of the
fields are checkboxes, the user ends up using the mouse to click through
selections, and then click on the next field, where there is already a [0]
zero entered as soon as you start entering data in the form, so that when the
user enters [2] two, the result ends up being [20] because of the zero that
was there already.

is there any way to get the form to stop entering zeros as defaults in the
numberic fields?

tia
 
Check to see if you have defaults specified for those controls. And check
whether the underlying table (for bound controls) has defaults specified.

Optionally, there's an Access option where it will select (highlight) the
entire field when it's tabbed into --- that way any typing will replace
what's already there.
 
Bob,

Thank you so much for pointing out the obvious to me - i went back to the
tables, and lo and behold, all the numeric values have "0" as the default
value.

is there a way to turn that off globally, so that when you're setting up new
tables, the default value doesn't get filled in?

thanks again for the prompt and helpful response!! (even though now i feel
pretty silly)
janaki
 
I don't see anything in the Access Options that would help with a different
default. Maybe someone else has an idea.... Bob.
 
Back
Top