leading zero in zip code fields how to get it to show

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a client data base, but when I type in east coast zip codes
those which start with (0) only the non zero numbers will appear. how can I
change the default to show the zero's
 
robeyone said:
I have set up a client data base, but when I type in east coast zip
codes those which start with (0) only the non zero numbers will
appear. how can I change the default to show the zero's
Click to expand...

Either...

Use a Text field instead of a Number field.

or

Set the Format property of the field to "00000".
 
I vote for Rick's first solution (use Text datatype).

After all, unless you are planning to add/subtract zipcodes, they aren't
really numbers, just characters that happen to be digits.

Regards

Jeff Boyce
<Office/Access MVP>
 
Jeff said:
I vote for Rick's first solution (use Text datatype).

After all, unless you are planning to add/subtract zipcodes, they aren't
really numbers, just characters that happen to be digits.

Regards

Jeff Boyce
<Office/Access MVP>
Click to expand...

I agree. Same applies to phone "numbers" (which, incidentally, haven't
always been numbers). What would you do if you need to send stuff to
Canada, where the ZIP code might be "L8N 2V5"?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top