New England Zip Codes

  • Thread starter Thread starter Bob Becker
  • Start date Start date
B

Bob Becker

I live in New England where we have ZIP codes starting with a zero.

I can get the preceding zero to print OK on tables using a 00000 mask,
but when I create labels the preceding zero is deleted.

How can I fix this?

TIA
 
If the data type is text, you can set the input mask to
Zip Code by using the three dots to the right of that
field in table design view. Does that work for your needs?
 
Bruce said:
If the data type is text, you can set the input mask to
Zip Code by using the three dots to the right of that
field in table design view. Does that work for your needs?
Click to expand...

That doesn't appear to work.
I need to have the preceding zero print on labels.

 
Bruce made a reference to the data being of "text" type. You might not have
an issue if you do this.
 
I live in New England where we have ZIP codes starting with a zero.

I can get the preceding zero to print OK on tables using a 00000 mask,
but when I create labels the preceding zero is deleted.

How can I fix this?

TIA
Click to expand...

**Change the datatype of the ZIP field to Text.**
Any field with numbers, which is not going to be used in calculations,
is best saved as a Text datatype.
The leading 0's are saved with the data.

If you are stuck with the number datatype for this ZIP field then
format it in the label's control source:
=[City] & ", " & [State] & " " & Format([ZIP],"00000")
Make sure the name of this control is not "City" or "State" or "ZIP".
 
Duane Hookom said:
Bruce made a reference to the data being of "text" type. You might not have
an issue if you do this.
Click to expand...

I did it.
The preceding zero was deleted from the field.
It did not appear.
 
fredg said:
If you are stuck with the number datatype for this ZIP field then
format it in the label's control source:
=[City] & ", " & [State] & " " & Format([ZIP],"00000")
Click to expand...

That works!

Thanks, Fred.
 
Convert a number to text using Format to ensure the number of digits:

strZIP = Format(lngZip, "00000")

Numbers are stored as binary in various forms and may have lead zero bits,
but "lead zero characters" are not part of that world.

Larry Linson
Microsoft Access MVP
 
Back
Top