leading zeros don't display

[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?

 

[Jeff Boyce]

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>