Trouble with 9-digit Zipcode

[liamrowan]

I have a table in which the ZipCode column has the following Input mask to return a 9-digit zip code: 00000\-9999;;_

In the table the zipcode fields look like 12345-6789. In the qry based on the table the zipcode fields look the same. In the report based on the query, however, some of the zipcode fields have the dash missing and look like 123456789.

The only hint I have is that the two fields that are missing the dash were fields that I added the zip four digits to today (before today they had only the 5-digit code). Still, these fields look correct in the table and related qry. Why not the report based on the query? And there are other zipcode fields in the report that have the dash. How am I ending up with some fields with and other fields without the dash?

Thx,

Wm

 

[vbaInet]

Copy the Format property value that's in the field in the table and paste in the Format property of the textbox on the report that is bound to the Zipcode.

 

[liamrowan]

There is nothing in the Format property value in the table; there is only the Input Mask for a nine-digit zip below the Format property value. I tried pasting that in the property in the report but that didn't work. Another idea?

Thx, Wm

 

[liamrowan]

I tried copying the Input Mask from the table into the Input Mask of the report and that worked. You pointed me in the right direction. Thx

 

[vbaInet]

Good job liamrowan!