zip coe

[Guest]

I created a database for labels in Access 2000 for our mailiing list. I
entered a field for the zip code. When I entered the data for the zip code,
I entered, for example, 45403. After I entered the 45403 the database added a
dash and space for four digits.

Our ministry uses the additional four spaces, so it was nice to see that the
database added it for me. So the zip code looked like this 45403-1234

However, when I printed the labels, the zip code printed 454031234, without
the dash. I really need the dash, but cannot find out what is wrong.

Anyone up to this challenge??? ...Jan

 

[fredg]

I created a database for labels in Access 2000 for our mailiing list. I
entered a field for the zip code. When I entered the data for the zip code,
I entered, for example, 45403. After I entered the 45403 the database added a
dash and space for four digits.

Our ministry uses the additional four spaces, so it was nice to see that the
database added it for me. So the zip code looked like this 45403-1234

However, when I printed the labels, the zip code printed 454031234, without
the dash. I really need the dash, but cannot find out what is wrong.

Anyone up to this challenge??? ...Jan

What you are seeing when you enter the zip code is the Input Mask.
However, you have not set up the mask to be saved with the data, so
while you see 45403-0000 the actual data is stored as 45403 or
454031234.

1) You can resolve future issues by changing the mask so it is saved
with the data.
The last 3 characters of the mask should be ;0;
This information is available in Access help.

This will not, however, change existing data.
(You can run an Update query to change the existing data to one with
the extra 4 characters.)

One way to print out your current zip codes in an address, regardless
of whether it is 5 or 6 or 9 or 10 characters, is the following

Using an Unbound text control:

=[City] & ", " & [State] & " " & IIf (Len([ZIP])>=9,Left([ZIP],5) &
"-" & Right([ZIP],4),Left([ZIP],5))

12345 or 12345- will print 12345
123456789 or 12345-6789 will print 12345-6789