zipcode

[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

 

[Joseph Meehan]

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

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.

 

[alex]

sorry. please explain were the input mask that youre
talking about. i'm new to "access"
alex

 

[Graham Mandeno]

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