Zip Code Placeholder

R

rdw1260

I'm using Access 2003. I have the following input mask: 00000\-9999;;_. When
the zip code data has 5 characters rather than 9, it displays the placeholder
"-". I used the following expression:
(IIf(Len([HomePostalCode])>=9,Left([HomePostalCode],5) & "-" &
Right([HomePostalCode],4),Left([HomePostalCode],5)))) in the query for the
form. It worked, but now I cannot enter any zip code data.

I'm a novice. How do I get the zip code field to not display the placeholder
when the zip code field has, 5 characters.

Thanks for any responses.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top