zip codes

  • Thread starter Thread starter john
  • Start date Start date
J

john

If i cant edit the table but i do have a form to enter new
data....if i have a field to enter a zip how do i force 5
chars in a number fiels under proporties...or if youhave
another way to do this in the form that would be great.

thanks
JOHN
 
John,

Zipcodes need to be defined as Text data, not Number data, as many locations
in the US have zipcodes that start with 0. If you try to use a Number
field, you cannot "force" it to accept those leading zeros. You can use:
00000;;_ as an input mask in your table or form to make sure that
5-digits are always entered.



hth,
 
Back
Top