zipcode

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

I have a access data I'm doing a mailing
went into (report) and (labels) put the zipcode
comes out as "123456789" instead of "12345-6789
any idea the (input mask) shows the zip as 12345-6789
sincerely Alex
 
alex said:
I have a access data I'm doing a mailing
went into (report) and (labels) put the zipcode
comes out as "123456789" instead of "12345-6789
any idea the (input mask) shows the zip as 12345-6789
sincerely Alex
Click to expand...

Access stores it as a number not text. You can display it as you like
by using the display properties in the form or report you are using.
 
sorry. please explain were the input mask that youre
talking about. i'm new to "access"
alex
 
Hi Alex

Joseph said the "display properties of the form or report".

I think what he meant was "the Format property of the textbox on the form or
report".

Set the Format property to:
00000-0000
 

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

Similar Threads

Input mask on my report! 4
why does zipcode in mailing labels print without seperator 1
InputMask 1
Input Mask question 2
How to write Left Function in VB 2
DoCmd.Transferspreadsheet - Data definition 1
Input masks 4
Split a string in one field into two fields 4

Back
Top