zip codes

[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

 

[Cheryl Fischer]

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,