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

[robeyone]

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

 

[Rick Brandt]

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

Either...

Use a Text field instead of a Number field.

or

Set the Format property of the field to "00000".

 

[Jeff Boyce]

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>

 

[Vincent Johns]

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>

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.