leading zeros don't display

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Would like to display leading zeros in both text and
number type fields. Can be entered manually, but when
entered via telephone input devices, the zero disppears.

Any suggestions?
 
Joe

Zeros (0) are "characters" in a text field, but leading zeros are irrelevant
in a number field. If you aren't going to be doing math on the field (for
example, do you need to "add" zip codes together?), use a text field type.

Also remember that you can use Format to force leading zeros to be
displayed, even when not actually stored.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top