leading zeros don't display

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

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>
 
Top